January 31, 2012 at 7:27 am
****This thread is continuation of the thread "Adding Linked Servers"****
Hi I have been trying to add some linked servers from one particular source server. I was able add some successfully while so were failing. The error message I got is as follows.
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI" for linked server "ADDING LINKED SERVERS" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "ADDING LINKED SERVERS" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". (Microsoft SQL Server, Error: 53)
So I went to the destination server to enable the server for Remote Connections.I saw the Surface Area Config Manager to check if remote connections were enabled or not. The default value selected was "Using Both TCP/IP and named pipes".
Even then the link server fails to add.
Any Ideas what might be the problem.
January 31, 2012 at 7:43 am
Duplicated post?
Please see mmy response http://www.sqlservercentral.com/Forums/Topic1243935-146-1.aspx
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply