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 |
|
SQLBuddy123
Starting Member
26 Posts |
 Posted - 2009-07-07 : 10:23:53
|
| Hi, We have done some migrations from SQL Server 2000 to SQL Server 2005. But the passwords in SQL Server 2005 are case sensitive. We didn’t notice that. So some SQL logins and Linked servers with forgotten passwords (Stored as Hashs) are not working. Could anyone tell me any method or software to retrieve those passwords? Thank You,Yours SQLBuddy. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-07-07 : 19:01:58
|
| No tool that I'm aware of. You can change the password at the target server (Saving it somewhere, of course) and then run around to each server that uses that login for the linked server security and update tyhe linked server definition to the new password.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-07-08 : 10:08:09
|
| HI Bustaz, Thank you very much for your reply. I really appreciate your help.YoursSQLBuddy |
|
|
|
|
|
|
Linked server password