OLE DB provider "SQLNCLI" for linked server "

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

SQL Server Administration (2005)

OLE DB provider "SQLNCLI" for linked server "

Author

Topic

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2009-10-03 : 13:28:53

Hello all

I installed SQLServer 2000 and SQLServer 2005 dev editions on XP and I am trying to create Link server between 2005 and 2000,I getting an error like this

OLE DB provider "SQLNCLI" for linked server "linksqldev2000" returned message "Communication link failure".
Msg 109, Level 16, State 1, Line 0
Named Pipes Provider: The pipe has been ended.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'sa'.

Please some guide me...where Iam making mistake,

SNIVAS

sanketahir1985
Starting Member

3 Posts

Posted - 2009-10-06 : 08:13:45

kindly check the security tab in linked server property
provide proper local and remote logins.

Sanket
Cloverinfotech Pvt. Ltd.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources