SQL Server Performance Forum – Threads Archive

Connection problem

I have a problem when connecting to the MS SQL Server 2000 with the MS SQL 2005 Management Studio using only TCP/IP protocol. Both servers are installed at the same host. The Named Pipes transport disabled as well as usage of the shared memory. When the Named Pipes are enabled the Management Studio can interact with SQL Server 2000 without any problem. The error message from TCP/IP provider said that server refused the connection. Thanks.

---

Did you enabled "Using both TCP/IP and Named Pipes protocols" in Surface Area Configuration? If not enable and try it…
Mohammed U.

---

Also look at this KBAhttp://support.microsoft.com/kb/914277&http://support.microsoft.com/kb/328306 for relevant connection issues resolution between the versions. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

]]>