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
zelfanetAsked:
Who is Participating?
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
pwd.png
0
 
Éric MoreauSenior .Net ConsultantCommented:
I hope you won't be able to get it as it would be a security issue!
2
 
zelfanetAuthor Commented:
I can still get into SQL Server Management Studio using Windows authentication.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Shaun VermaakTechnical Specialist/DeveloperCommented:
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.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
Pawan KumarDatabase ExpertCommented:
>>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.
0
 
Jackie ManCommented:
Agreed.

Reset the password is a better option.
0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
#a42371033 works for a fact. See screenshot in #a42372260
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Agree with Shaun's last comment.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Shaun's comment has the justification. His screenshot clearly shows the password.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.