May 23, 2008 at 7:39 am
Yesterday I change a production password - well it has killed the application. I did take a backup of master before the change.
We are looking on the application server for where the password may have been stored. Is there anyway to retrieve the password from yesterday?
Could I restore master and get it back - but not restore the other databases?
May 23, 2008 at 8:08 am
Changing the password in the connection string not an option then? A new app password never hurt anyone 😉
"Got no time for the jibba jabba!"
-B.A. Baracus
May 23, 2008 at 8:30 pm
Yes, you can restore master and get it back without restoring the other databases. The catch is what else changed since that backup?
Another option would be to try and restore master to a system with the same setup (drives, etc.) that's not production and extract the login.
How to transfer logins and passwords between instances of SQL Server
If there are other changes that have happened you don't want to lose, that'll let you recover the login and password.
K. Brian Kelley
@kbriankelley
May 27, 2008 at 2:41 pm
Could she restore Master to a test box, and extract just the 1 row for that login ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply