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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2004-08-09 : 04:23:24
|
| I have two servers. First one have 'sa' login with no password, and the second one have 'sa' login with password (changed few days ago).I tried this:select * into SecondServer.Database2.dbo.Table2from FirstServer.Database1.dbo.Table1 and I get message:Server: Msg 18456, Level 14, State 1, Line 1Login failed for user 'sa'.How to solve this problem |
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2004-08-09 : 06:04:30
|
| Me again. I done sp_addlinkedserver long time ago, when SecondServer had 'sa' login without password. 'Select into' statement worked with no problem. But with different password for 'sa'it doesn't works. How can I connect two servers with different passwords. |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-09 : 12:28:34
|
| map the logins? |
|
|
|
|
|
|
Login failed for user 'sa'