September 2, 2010 at 8:05 am
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)
September 2, 2010 at 8:54 am
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.
September 3, 2010 at 3:38 am
just check whether 'Allow remote connections to this server ' is checked or not in your 2005 server properties.
September 3, 2010 at 8:25 pm
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