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.
| Author |
Topic |
|
vsjayashri
Starting Member
4 Posts |
 Posted - 2008-05-22 : 09:27:37
|
| Hi I have a scenario please helpI have 2 servers A and B DB1 is the database in A and DB2 is the database in Bwant to fetch the records from the server B in DB2. My query is select * from B.DB2.dbo.table1when i issued this statement in server A from database DB1 got the following error...OLE DB provider "SQLNCLI" for linked server "B" returned message "Communication link failure".Msg 10054, Level 16, State 1, Line 0TCP Provider: An existing connection was forcibly closed by the remote host.Msg 18456, Level 14, State 1, Line 0Login failed for user 'sa'.How to solve this issue.(Note - login for SERVER A - sa/<nopassword>login for SERVER B - sa/master) |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2008-05-22 : 10:18:12
|
quote:
Originally posted by vsjayashri
Hi I have a scenario please helpI have 2 servers A and B DB1 is the database in A and DB2 is the database in Bwant to fetch the records from the server B in DB2. My query is select * from B.DB2.dbo.table1when i issued this statement in server A from database DB1 got the following error...OLE DB provider "SQLNCLI" for linked server "B" returned message "Communication link failure".Msg 10054, Level 16, State 1, Line 0TCP Provider: An existing connection was forcibly closed by the remote host.Msg 18456, Level 14, State 1, Line 0Login failed for user 'sa'.How to solve this issue.(Note - login for SERVER A - sa/<nopassword>login for SERVER B - sa/master)
Are each server on the same service pack of SQL Server? |
 |
|
|
vsjayashri
Starting Member
4 Posts |
Posted - 2008-05-22 : 10:26:43
|
| yes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 10:28:42
|
| Why are you using sa login for Linked server? Try using sql login and What editions are SQL servers? |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2008-05-22 : 10:47:57
|
quote:
Originally posted by vsjayashri
yes
A default mapping between all logins on the local server and remote logins on the linked server is automatically created by executing sp_addlinkedserver. The default mapping states that SQL Server uses the local login's user credentials when connecting to the linked server on behalf of the login (equivalent to executing sp_addlinkedsrvlogin with @useself set to true for the linked server). Use sp_addlinkedsrvlogin only to change the default mapping or to add new mappings for specific local logins. To delete the default mapping or any other mapping, use sp_droplinkedsrvlogin. |
|
|
|
|
|
|
|
|
Link - other servers