Link two servers to copy data

Asked Jul 22 '13 at 11:08

Active Apr 22 '15 at 16:52

Viewed 555 times

I'm trying to copy data from a DB in one server to a DB in another server. To copy data I know that I need to link the two servers, but nothing is working.

I followed this link to link my two servers, but it returns me these error messages:

OLE DB provider "SQLNCLI10" for linked server "MyServerToLink" returned message "Login timeout expired". OLE DB provider "SQLNCLI10" for linked server "MyServerToLink" 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.". Msg 53, Level 16, State 1, Line 0 Named Pipes Provider: Could not open a connection to SQL Server [53].

edited Apr 22 '15 at 16:52

Mureinik

297,002
52
306
350

asked Jul 22 '13 at 11:08

Camilla

Check firewall settings. – Arvo Jul 22 '13 at 11:17
First check in both servers **[this](http://msdn.microsoft.com/en-us/library/ms191464.aspx)**. – Gaston Flores Jul 22 '13 at 11:54
done, they both are checked to "allow remote connections" – Camilla Jul 22 '13 at 12:17
This type of error arises when the remote DB server is OFFLINE or the login details are incorrect. – Prahalad Gaggar Jul 22 '13 at 13:36

Link two servers to copy data

0 Answers0