Connection Error (Sql 2005/2008)

  • I am able to connect to my 2005 servers from 2008 instance but not vice versa and getting the following error when tried so...

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 121)

  • are you doing a linked server? if not how are your trying to connect?

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • just check whether 'Allow remote connections to this server ' is checked or not in your 2005 server properties.

  • It is checked in both servers.

Viewing 4 posts - 1 through 3 (of 3 total)

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