SQL2005 Linked Server to SQL2008

  • We've been using Linked Servers under Server Objects in SQL2005 quite successfully with SQL2000 and SQL2005 environments as well as Sybase and others, etc. We are moving towards SQL2008 and with the addition of one of these environments, I have been unable to establish the link to SQL2008 from SQL2005..

    Failed to retrieve data for this request (Microsoft.SQLServer.SmoEnum)

    An exeception occurred while executing a Transact-SQL statement or batch

    (Microsoft.SQLServer.ConnectionInfo)

    Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQLServer, Error: 2)

    SQL2005 SP2 Incremental #6

  • u might need to enable named pipes in the SSMS config manager, right? off by default, I think

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply