在建立时发生与网络相关或特定于实例的错误.错误:26

本文关键字:错误 于实例 实例 建立 网络 | 更新日期: 2023-09-27 17:53:31

我在我的asp.net项目工作;当我运行我的程序时,它停止运行并给我这个消息:

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 

在建立时发生与网络相关或特定于实例的错误.错误:26

此问题与连接字符串有关,

  1. 检查实例服务器
  2. 检查用户名和密码

连接字符串:

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

如果您有实例,请确保在server中指定instance,例如:

=

服务器。' SQL2008

当您的sqlServer服务被停止或当您的TCP端口被更改时,此异常会抛出,因此请检查该异常。

我们将端口信息添加到连接字符串中,从而减轻了此错误。例如:

服务器

= servername , 端口# ;数据库= 数据库名;…

我得到了错误,因为我的DataSource被命名为

(localdb) ' v11.0

和c#中的反斜杠被解释为一个特殊字符,因此需要像下面这样转义:下面的行可以工作!但是单个"'"不行

String source = "Data Source=(localdb)" + "''" + "v11.0;Initial Catalog=Northwind;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(source); 
conn.Open();

我得到了同样的错误,我的连接字符串是正确的。我尝试使用SQL Server的ip地址而不是服务器名称。最后,这个错误消失了。

我使用这个连接字符串

 <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" />

代替

<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" />