积极答复者
用SQL2005的客户端连接服务器上的SQL2000,连接不上

问题
-
说下背景,SQL2000是装在server08的服务器上的,打过了SP4,之前服务器上有装过SQL2005和SQL2008,实例名统一为服务器名称\sql200x,我本机装的是SQL2005和SQL2008,我用SQL2005的客户端打开服务器上的SQL2005,没有任何问题,但是打开SQL2000就打开不了,出现的错误看起来很像是被什么阻止了,我在服务器上用SQL2005客户端去连接SQL2000,可以的,后来关掉了服务器防火墙,还是不行,到底是哪里不对??之前在server03上也是这样的模式安装过这三个版本的SQL,什么都没弄就能连上
snoopy
答案
-
Edition is not the issue nor default instance. Named instance uses dynamic port number, you need specify correct port number when connect to it if sql browser service is not running. And ensure that port is open on your network.
- 已标记为答案 Nai-dong Jin - MSFTModerator 2010年8月26日 3:23
全部回复
-
-
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)
snoopy -
Did you put in correct sql instance name? Yes ,checked many times.Is named pipes or tcp/ip protocol enabled in that instance? yes, checkedIs that instance running? In server locale, can connectedCan you connect to it with sql2k enterprise manager? yes, in server locale,my pc not install sql2000
snoopy -
Edition is not the issue nor default instance. Named instance uses dynamic port number, you need specify correct port number when connect to it if sql browser service is not running. And ensure that port is open on your network.
- 已标记为答案 Nai-dong Jin - MSFTModerator 2010年8月26日 3:23