Linked Server to Second machine instance

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  September 19, 2006 at 1:06 pm

  #61806

  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  

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  September 19, 2006 at 2:38 pm

  #661364

  See my reply to your question on SQL Server 2005 forum

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=309730

  Regards,Yelena Varsha