sql-server – 使用TCP / IP连接到SQL Server 2008

发布时间：2020-12-12 08:33:24 所属栏目：MsSql教程来源：网络整理

导读：当我尝试从SQL Server Management Studio连接TCP / IP时,我收到以下错误.我需要一步一步的描述来解决我的问题.这里有什么问题？ Cannot connect to ===================================A network related or instance specific error when a connection to S

当我尝试从SQL Server Management Studio连接TCP / IP时,我收到以下错误.我需要一步一步的描述来解决我的问题.这里有什么问题？

Cannot connect to 
===================================

A network related or instance specific error when a connection to SQL Server...
(provider: Named pipe-provider,error: 40 -  SQL Server)
(.Net SqlClient Data Provider)

------------------------------
For help,click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
Error Number: 53
Severity: 20
State: 0

------------------------------
Program Location:

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   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,SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host,Boolean redirectedUserInstance,SqlConnection owningObject,SqlConnectionString connectionOptions,Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject,Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,Object providerInfo,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()

解决方法

我通常忘记的是,即使在MSSQLServer的SQLServerNetwork->协议中标记为tcp,您仍然需要为服务器启用潜在的不同IP地址.即使具有单个NIC的服务器也将具有多个IP地址.

>单击上面列出的MSSQLServer协议.>然后在右侧窗格中启用TCP / IP.>现在双击TCP / IP获取对话窗口.>如果要监听服务器的所有IP地址,请选择“是”在第一个协议选项卡上侦听全部框;除此以外>选择IP地址选项卡,并通过设置Enabled启用所需的IP地址到是的.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!