sql连通性问题 [英] sql connetivity issue

问题描述

要检查sql server是否已启动并正在运行并且正在侦听我的计算机中的适当协议的路径是什么?因为我有连接问题.

错误是

建立与服务器的连接时发生错误.连接到SQL Server 2005时，此故障可能是由于以下事实导致的:在默认设置下，SQL Server不允许远程连接. (提供者:命名管道提供者，错误:40-无法打开与SQL Server的连接)

我的代码是

what is the path to go and check if sql server is up and running and is listening on appropriate protocols in my machine? coz i m having a connectivity issue.

The error is

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

my code is

推荐答案

开始菜单>>程序>> Microsoft SQL Server 2008>>配置工具，启动SQL Server配置管理器并启用连接协议

重新启动sql服务或重新启动计算机.

^ ]

Start Menu>>Programs>>Microsoft SQL Server 2008>>Configuration Tools, launch SQL Server Configuration Manager and enable the connection protocol

restart the sql service or restart machine.

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/[^]

确保启用了远程连接-请参见 ^ ].

Make sure remote connections are enabled - see here[^].

这篇关于sql连通性问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！