zelfanet
asked on
SQL Server password
Hello,
I have SQL server 2008 r2 setup on a Windows 10 pc. Everything works fine. When I log in to Microsoft SQL Server Management Studio the password is auto saved and allows me to log in. How can I get this password?
Thanks
I have SQL server 2008 r2 setup on a Windows 10 pc. Everything works fine. When I log in to Microsoft SQL Server Management Studio the password is auto saved and allows me to log in. How can I get this password?
Thanks
I hope you won't be able to get it as it would be a security issue!
ASKER
I can still get into SQL Server Management Studio using Windows authentication.
You can try ShowPW.exe from http://www.scalabium.com
I suspect this is stored as an NT secret which you can get via SYSTEM account
https://www.experts-exchange.com/articles/30792/How-to-run-commands-using-SYSTEM-account.html
I provide this info assuming that you are authorized to use this system etc.
I suspect this is stored as an NT secret which you can get via SYSTEM account
https://www.experts-exchange.com/articles/30792/How-to-run-commands-using-SYSTEM-account.html
I provide this info assuming that you are authorized to use this system etc.
Unless you know some good hacker, you shouldn't be able to retrieve that password.
If you need to know the password to use it somewhere else, why don't you reset it? You just need to logon with another user that has administrator privileges to perform the password reset.
If you need to know the password to use it somewhere else, why don't you reset it? You just need to logon with another user that has administrator privileges to perform the password reset.
>>How can I get this password?
No you will not get the password directly. Some tool/technique may or may not help. But using that is not a very good idea.
Why you want to change it. ? Is there any requirement.
No you will not get the password directly. Some tool/technique may or may not help. But using that is not a very good idea.
Why you want to change it. ? Is there any requirement.
Agreed.
Reset the password is a better option.
Reset the password is a better option.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
#a42371033 works for a fact. See screenshot in #a42372260
Agree with Shaun's last comment.
Shaun's comment has the justification. His screenshot clearly shows the password.