Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011

    Unanswered: Link Server Issue

    Hi...I have an issue. My computer using SQL 2005. and i want to create Link Server to Server that using SQL 2008. But the case is, in the server there are SQL 2005 and SQL 2008 installed. when i create the link server, the link server always connect to SQL 2005 by default. how to connect to the SQL 2008? thx

  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    It sounds like the default instance (MSSQLSERVER) is SQL Server 2005, while 2008 is a named instance. You'll typically connect using the instance name (MyServer\MyInstanceName)
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts