Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2007-10-05 : 16:00:25
|
I have a new server SQL 2005 im setting up a linked server to my 2000 box, however the connection is being refused: Error 10061.The strange part of it is.I have other SQL 2000 machines that can connect to this box over the linked server, and I have one linked server from 2005 to a different 2000 box working.From remote desktop on my new 2005 box I can ping and connect via object explorer to the machine in question. One difference that exists between the 2000 server I can link to and the one that I can not is the port.The box I can not connect to is on 2433 with the hide server option turned on.Yes I have tried both the IP and Named pipe with port information when connecting.Your assistance is appreciated.Thank you. You can do anything at www.zombo.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-05 : 16:04:21
|
| Setup an alias on the new server pointing to the name of the linked server and make sure to specify the actual server name, TCP/IP and proper port in it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Connection Refused