SQLTeam.com | Weblogs | Forums

Insert Into From on table to another but from different servers


#1

I want to move data from a table T1 on Server1 to table T2 on Server2 and I am using the following Query.

INSERT INTO [Server1].[DB1].[dbo].[T1]
SELECT * FROM [Server2].[DB2].[dbo].[T2]
But it is returning the following error.

OLE DB provider "SQLNCLI11" for linked server "HUZAIFA" returned message "Login
timeout expired".
OLE DB provider "SQLNCLI11" for linked server "HUZAIFA" 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].


#2

check (and post) your linked server definitions and firewall settings