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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-02-25 : 17:10:41
|
| how can I create a sql login login2 with the same password as login1 if I am an administrator and I don t know what the password of login1 is?ThanksP.S: It s just that I m creating script automating changing domain name in sql logins and sql DB users becuase that didn't happen automatically after a windows migrationThank you. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-25 : 17:13:29
|
| there is a way to get the hashed value of the password for an existing account, and then use that when creating a new account.the sp_helprevlogin script does just that. You will have to google for it, or search microsoft's KB articles for it since it is an add-on script from microsoft.-ec |
 |
|
|
|
|
|
creating login2 with same password as login1