"Instance failure."

[zhshqzyc]

Hi,

I created a SQL database "Weather" with SQL Server Management Studio Express 2005.
It worked fine before yesterday but today I am frustrated.

I tried test connection but failed and I got an error "Instance failure."
The message from log file is

2008-02-05 09:59:38.92 Server Error: 26023, Severity: 16, State: 1.

2008-02-05 09:59:38.92 Server Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.

2008-02-05 09:59:38.93 Server Error: 17182, Severity: 16, State: 1.

2008-02-05 09:59:38.93 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.

2008-02-05 09:59:38.95 Server Error: 17182, Severity: 16, State: 1.

2008-02-05 09:59:38.95 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.

2008-02-05 09:59:38.95 Server Error: 17826, Severity: 18, State: 3.

2008-02-05 09:59:38.95 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2008-02-05 09:59:38.95 Server Error: 17120, Severity: 16, State: 1.

2008-02-05 09:59:38.95 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


I hope somebody can help me.

Thanks

[zhshqzyc]

I forgot to post the detail error message that is
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

[nunommc]

Hi,

I was having the same problem, and I solved right now.

1st I tried with all protocols Enabled (Named Pipes, TCP/IP, VIA) and didnt work.

2nd I realized tha the problem was on the connection string:


tring ConnectionString = @"Initial Catalog=test_db;" +
@"Data Source=(local)\\SQLEXPRESS;" +
@"User ID=myTestUsr;" +
@"Password=myTestPwd";


There are 2 possible solutions
- remove the "@" and write 2 slashes before SQLEXPRESS
- write "@" before the string, but have only one slash before SQLEXPRESS

I hope this helps,
good luck

[AZIZUR_CSE]

Yes ,I also caught same problem.This stupid problem lost my two days .Now I solved it by removing
"@ "..Thanks a lots