Examples:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Instance failure.
Are there known issues related to ASP.NET Mobile Controls, SQL Server 2005 Express Edition, .NET Framework 1.1 or 2.0?
Thank you.Hi,
Is the SQL Express on a different machine? If so take a look at the following blog to troubleshoot issues with a remote connection:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Regards,
Vikram|||Thank you for Your answer, Vikram.
But I have Visual Web Developer and SQL Server 2005 Express Edition on the same machine.|||Hi,
Have you been able to connect to the SQL Express Database using the Express Manager? What is the ConnectionString you are using ?
The default instance of SQL Server Express would need to be referenced as
.\SQLExpress or MachineName\SQLExpress
Regards,
Vikram|||Hallo Vikram,
yes, it is possible to connect with XM and the connection string fits.
From Visual Web Developer Beta 2 to SQL Server 2005 Express Edition I have the following error log with my mobile application:
2005-07-25 14:38:59.90 Logon Error: 17830, Severity: 20, State: 2.
2005-07-25 14:38:59.90 Logon A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 7 ms, enqueued 2 ms, network writes 1 ms, network reads 4 ms, establishing SSL 5 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]
2005-07-25 14:38:59.92 Logon Error: 17830, Severity: 20, State: 2.
2005-07-25 14:38:59.92 Logon A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 9 ms, enqueued 1 ms, network writes 1 ms, network reads 8 ms, establishing SSL 5 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]
I do not know why but the connection works with other applications.
I think I have to create a user for the mobile application with the right permissions.
Thank you.
No comments:
Post a Comment