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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

É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
Shaun VermaakTechnical SpecialistCommented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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 ManIT ManagerCommented:
Agreed.

Reset the password is a better option.
0
Shaun VermaakTechnical SpecialistCommented:
pwd.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Shaun VermaakTechnical SpecialistCommented:
#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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.