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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-24 : 08:46:12
|
| Dejan writes "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" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-09-24 : 09:33:52
|
| Did you changed the password in the linked server for SecondServer ??- Sekar |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-24 : 09:37:20
|
| Use the same SA password on both servers?Set up the a new UserID, with the same password, on both servers and login using that.I would be pretty scared about using SA to access a system. If I want to access a machine with SA here I have to go to the safe, get an envelope with the SA password (which is about a yard long), use that, generate a new password, reset the password in SQL, update the note and save it back in the safe. That's sufficient of a disincentive that I don't do it!Kristen |
|
|
|
|
|
|
Login failed for user 'sa'.