SQL server Linked Servers at client side

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL server Linked Servers at client side

Author

Topic

sachin.hingole
Starting Member

15 Posts

Posted - 2009-01-03 : 04:48:41

Hi everybody,

I have added the linked server on the development server using following system procedures,
but when I'm trying to access the tables from linked server(production) then it gives the error message below in bold.
EXEC sp_addlinkedserver 'productionserver name', 'SQL Server'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname ='productionserver name',
@useself = 'false',
@locallogin = 'sa',
@rmtuser = 'sa',
@rmtpassword = 'pass'
OLE DB provider "SQLNCLI" for linked server "172.16.10.29" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "172.16.10.29" 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.".
Msg 2, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [2].

thanks in advance,

Sachin Hingole

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-03 : 06:37:31

is remote connections enabled for server you're trying to connect? you need to enable this in sql surface area configuration manager.