用SQL2005的客户端连接服务器上的SQL2000，连接不上

Question

说下背景，SQL2000是装在server08的服务器上的，打过了SP4，之前服务器上有装过SQL2005和SQL2008，实例名统一为服务器名称\sql200x，我本机装的是SQL2005和SQL2008,我用SQL2005的客户端打开服务器上的SQL2005，没有任何问题，但是打开SQL2000就打开不了，出现的错误看起来很像是被什么阻止了，我在服务器上用SQL2005客户端去连接SQL2000，可以的，后来关掉了服务器防火墙，还是不行，到底是哪里不对？？之前在server03上也是这样的模式安装过这三个版本的SQL，什么都没弄就能连上

---

snoopy

Answer 1

It should work. What was the error?

Answer 2

http://blog.csdn.net/zyxlsh/archive/2009/09/23/4584809.aspx

Answer 3

 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

Answer 4

我的都是32位，不管是服务器还是SQL SERVER，都是32位

---

snoopy

Answer 5

Did you put in correct sql instance name? Is named pipes or tcp/ip protocol enabled in that instance? Is that instance running? Can you connect to it with sql2k enterprise manager? ...

Answer 6

Did you put in correct sql instance name?      Yes ,checked many times.

Is named pipes or tcp/ip protocol enabled in that instance?   yes, checked

 Is that instance running?   In server locale, can connected

Can you connect to it with sql2k enterprise manager?  yes, in server locale,my pc not install sql2000

---

snoopy

Answer 7

Which port is it listening on? You can find it in sql server manager, then try connect with host_name,port_number.

Answer 8

default port:1433  i tried use netstat -na, but can noe see the 1433 port

 

---

snoopy

Answer 9

Try 'telnet host_name 1433' in dos prompt on remote machine, double check firewall settings on your netowrk if doesn't work.

Answer 10

呵呵，我不知道问题在哪里，但是我在卸载重装的时候，改变了两个地方。

第一，我这次装的是标准版，上次装的是开发版，我不确定是否是个影响；

第二，这次我没有用命名实例，我用的是默认的，我不懂是不是因为SQL三个版本要是共存的话必须有一个默认实例的缘故，因为之前的都是\SQL2005和\SQL2008，这次就用了默认实例，安装后正常装SP4。装完后重启，没有做任何的设置，远程的SQL2005客户端就可以连接SQL2000了。

希望高手解开我的疑惑

---

snoopy

Answer 11

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.

Answer 12

you need specify correct port number when connect to it if sql browser service is not running

这里的sql browser service 是指客户端还是服务器上SQL2005的？不管是哪个，我应该都是开了的。

And ensure that port is open on your network.

这个我防火墙全部关掉的。

---

snoopy

Answer 13

Sql browser service runs on sql server only. Did you try telnet by the way?