An error has occurred while establishing a connection to the server

来源:百度知道 编辑:UC知道 时间:2024/09/18 05:27:50
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

我的数据库(sql2000)在另外一台电脑(A)上,如果直接用企业管理器就可以访问(A)电脑上的数据库,但是在项目中(VS2005)连数据库就出现上面报的错误,还有就是sql2000怎么报错2005呢?也没装2005.请高手帮忙解决一下,小弟先谢了!

[转]数据库连接错误: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)

数据库和空间要在同一台服务器上,如果要外联,就要在数据库控制面板中的 允许远程访问IP 中,设置要连接数据库的Ip

http://www.zhuhongwen.com/post/14.html

看看可以解决么?sql2000要打sp4的补丁,不然是不让连接的

一个错误在建立到服务器的连接时发生

连接服务器时发生错误