Error in Sp_AddLinkedServer - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Error in Sp_AddLinkedServer

Author

Topic

praveenkumar_k
Starting Member

2 Posts

Posted - 2008-11-05 : 01:53:01

All,
I have created a linked server and try to execute a query.
It throws error like

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

exec sp_addlinkedserver
@server='SRCSVR',
@srvproduct= '',
@provider='SQLNCLI',
@datasrc='SERVER=XXXX;UID=MyUser;PWD=MyPwd'

Thanks,
Praveen Kumar Krishnan

praveenkumar_k
Starting Member

2 Posts

Posted - 2008-11-05 : 01:58:25

I tried to execute this Quert

select * from SRCSVR.DBName.dbo.TableName

Thanks,
Praveen Kumar Krishnan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources