0

I am working in my asp.net project; when I run my program, it stops running and gives me this message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Server Error in '/Test2' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:


Line 27:         string cmdString = "Delete from tblSessionCart";
Line 28:         SqlCommand cmd = new SqlCommand(cmdString, conn);
Line 29:         conn.Open();
Line 30:         try
Line 31:         {


Source File: c:\Users\mousa\Desktop\Test2\App_Code\clsSessionCart.cs    Line: 29

Stack Trace:

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4876455
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +354
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +401
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +225
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +4889331
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +431
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   clsSessionCart.DeleteCart() in c:\Users\mousa\Desktop\Test2\App_Code\clsSessionCart.cs:29
   ASP.global_asax.Session_Start(Object sender, EventArgs e) in c:\Users\mousa\Desktop\Test2\Global.asax:27
   System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +8878884
   System.Web.SessionState.SessionStateModule.CompleteAcquireState() +237
   System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +504
   System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +66
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155


Version Information: Microsoft .NET Framework Version:2.0.50727.5477; ASP.NET Version:2.0.50727.5479
neminem
  • 2,658
  • 5
  • 27
  • 36
user3464877
  • 1
  • 1
  • 1
  • 1
  • Your SQL Server is not set to accept remote connections. See [7 things to check to resolve “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”](http://www.sswug.org/articlesection/default.aspx?TargetID=44331) – Habib Mar 26 '14 at 15:33
  • could you show your connection string? this problem is related to your connection string. – Hadi Sharifi Mar 26 '14 at 16:07
  • 1
    I am getting the same error but happening intermittently. Any ideas? – Hamid Shahid May 01 '14 at 11:37
  • 3
    possible duplicate of [A network-related or instance-specific error occurred while establishing a connection to SQL Server](http://stackoverflow.com/questions/1391503/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne) – durron597 Sep 14 '15 at 02:31

5 Answers5

1

This problem is related to connection string,

  1. Check instance server
  2. Check user and password

Connection string:

Server=YOUR_SQLSERVER_INSTANCE;Database=YOUR_DATABASE_NAME;User Id=sa;Password=YOUR_SA_PASSWORD;

If you have instance, make sure instance is specified in server, for example:

Server=.\SQL2008

Hadi Sharifi
  • 1,497
  • 5
  • 18
  • 28
0

This exception throws when your sqlServer service is stopped or when your TCP port is changed, so check for that one.

Mohini Mhetre
  • 912
  • 10
  • 29
0

We added the port info to our connection string which alleviated this error. For example:

server=servername,port#;database=databasename;....

user3606172
  • 1
0

I got the error because my DataSource was named

(localdb)\v11.0

and in C# the backslash is interpreted as a special character so needs to be escaped as follows : the below lines will work! But single "\" fails.

String source = "Data Source=(localdb)" + "\\" + "v11.0;Initial Catalog=Northwind;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(source); 
conn.Open();
Wim Ombelets
  • 5,097
  • 3
  • 39
  • 55
David
  • 1
0

I got the same error, and my connection string is correct. I try to use ip address of SQL Server instead of server name. Finally, this error has gone.

I use this connection string

 <add name="YourEntitiesName" connectionString="metadata=res://*/Model.SampleDatabaseModel.csdl|res://*/Model.SampleDatabaseModel.ssdl|res://*/Model.SampleDatabaseModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=10.123.60.12\SQLServerName;initial catalog=SampleDB;user id=sa;password=123456;MultipleActiveResultSets=True;Pooling=False;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

instead of 

<add name="YourEntitiesName" connectionString="metadata=res://*/Model.SampleDatabaseModel.csdl|res://*/Model.SampleDatabaseModel.ssdl|res://*/Model.SampleDatabaseModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=SERVER01\SQLServerName;initial catalog=SampleDB;user id=sa;password=123456;MultipleActiveResultSets=True;Pooling=False;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
Goldarrow
  • 11
  • 2