September 19, 2006 at 1:11 pm
All
I have a SQL Server 2000 instance and SQL Server 2005 instance on a single machine.
I currently have a link server connection to my SS2000 instance from my production machines. I would like to add a second link server to my produciton machine that points to my SQL Server 2005 instance. I have my hosts file to point as follows
10.133.10.xxx AdhocSS2000
10.133.10.xxx\SQL01B AdhocSS2005
where adhocSS200 is my existing SQL Server ( this link works ) and AdhocSS2005 the link dosent work
Any ideas on how to get this to connect to the second SQL Server 2005 instance?
Eric
September 19, 2006 at 2:23 pm
I would use Client Network Utility because you have to specify the port as well probably. Also check if the port is open to the instance port between servers. You may want to check if SQL Browser service is running. But first of all check that TCP/IP is enabled for the network connections on 2005 instance because by default it is not enabled, see BOL article "Default SQL Server Network Configuration", it lists protocols if they are enabled or disabled based on the edition of SQL Server 2005.
Regards,Yelena Varsha
September 19, 2006 at 3:02 pm
My server is configured to accept remote connections.
TCPIP is enabled
The the ports are open between the machines, but I will try to use the a port setting on the machine.
Thanks
Eric
September 20, 2006 at 8:38 am
All
Got it to work.
It will not work just by checking the standard SQL Server raido button as that will default to the instance that is named the same as the server.
Checked Other Data Source
Provider: SQL Native Client (SQLNCLI if using sp_addlinkedserver)
Data source IP Address\ServerName
Then it works. Thanks for all of your help. The following link provided the best resource for tracking down the problem. http://msdn2.microsoft.com/en-us/library/ms190479.aspx
Eric
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply