您所在位置：主题：[求助]VS2005连不上远程数据库!
xclw0
[专家分：0] 发布于 2006-06-05 09:41:00
本机上装了VS2005+SQL SERVER 2005.现在要连远程数据库!如果对方的机子上装了SQL SERVER 2005,连接不会出现问题.如果没有装,只是装了SQL SERVER 2000.就会出现如下错误.
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)
我在设置中已经允许远程连接了,并打开了TCP/IP和Name Pipe.
我就不明白了,干嘛一定要连到SQL SERVER 2005,连到2000 不行吗?在企业管理器中我能够把那个号称连不上的SERVER加入SQL SERVER GROUP,并自由打开！就是当用代码OPEN()的时候会出错.
知道如何解决的XDJM帮忙呀!
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)
我在设置中已经允许远程连接了,并打开了TCP/IP和Name Pipe.
我就不明白了,干嘛一定要连到SQL SERVER 2005,连到2000 不行吗?在企业管理器中我能够把那个号称连不上的SERVER加入SQL SERVER GROUP,并自由打开！就是当用代码OPEN()的时候会出错.
知道如何解决的XDJM帮忙呀!