Friday, March 9, 2012

Errors ASP.NET to SQL Server 2005 Express Edition

If I try to use mobile web applications created with Visual Studio .NET 7.1 in conjunction with SQL Server 2005 Express Edition on my locale computer I get a lot of errors.

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