May 25, 2010 at 9:13 am
I have a sql login AUser on ServerA.DatabaseA and now restored the same database to ServerB.DatabaseB but i am missing the login Auser andi dont rememebr the password for the same user to recreate on ServerB.
How do i transfer the login to ServerB wihtout changing the password or how do i find the password as i have no option for resetting the password.
May 25, 2010 at 9:20 am
The easiest way is to use these scripts provided by MS.
May 25, 2010 at 9:20 am
I did run sp_help_revlogin to transfer logins but is there a way to find the paswd for that account ?
May 25, 2010 at 9:22 am
not so you can understand it, but the script should also script out the encoded password
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply