By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,410 Members | 1,626 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,410 IT Pros & Developers. It's quick & easy.

sp_linkedservers did not help in linking server

P: 62
Hi Team,

I am trying to run a query on my local system and trying to access a table from a remote server..here is the query:

select * from SERVER.DATABASE.DBO.TABLE

This query is working fine but when I am trying to access the same from db server I am getting error as given below:

TCP Provider: An existing connection was forcibly closed by the remote host. Login failed for user 'USER'. OLE DB provider "SQLNCLI" for linked server "SERVER" returned message "Communication link failure".


Please help!!
Feb 15 '10 #1
Share this Question
Share on Google+
5 Replies


ck9663
Expert 2.5K+
P: 2,878
Did linked the server yet?

Good Luck!!!

~~ CK
Feb 16 '10 #2

P: 62
it linked after mapping a local sql user to a server sql user..but as per our dbAdmin it's not a secure way and it will have a ongoing dedicated connection both the database..which should not be the case.

Can anyone confirm that link server build a dedicated connection with the linked server?
Feb 17 '10 #3

P: 62
just poasting for ppl looking ard the same solution - what really worked for me was -

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'RemoteServerName'
, @useself = 'false'
, @locallogin = 'LocalSqlUSER'
, @rmtuser = 'SeverSqlUser'
, @rmtpassword = 'SeverSqlPassword'


Thanks,
Manik
Feb 17 '10 #4

sashi
Expert 100+
P: 1,754
Which edition of SQL Server are you working with?
Feb 17 '10 #5

sashi
Expert 100+
P: 1,754
Can anyone confirm that link server build a dedicated connection with the linked server?
Kindly refer to below attached link, hope it helps.

Benchmark for Microsoft SQL Server 2005
Feb 17 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.