Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Unable to verify Linked Server

New Instance installed on SQL Server. Same server that was running dbamp before.

I have moved the database to the new server but the linked server to salesforce fails to verify.

Here is the message.

TITLE: Microsoft SQL Server Management Studio
------------------------------

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 "SQLNCLI11" for linked server "SALESFORCE" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "SALESFORCE" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdNa...

------------------------------
BUTTONS:

&Yes
&No
------------------------------
1 person has
this problem
+1
Reply