find forgotten password sql login 2012

hello,

I sarch a script to find forgotten password sql login 2012.

Thanks

Regards
bibi92Asked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That's better. At least someone still has control on the SQL Server instance.
You can't retrieve SQL Server passwords. What you can do is change the password for that login so the user can use the new password to work.
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
here's an article explaining how to create a backdoor sa account which will allow you to reset other sa accounts passwords

http://technet.microsoft.com/en-us/magazine/jj853293.aspx
0
 
Walter PadrónCommented:
Any member of Local Administrators group can connect to SQL, try to logon using Windows credentials and if successful change the password.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Any member of Local Administrators group can connect to SQL
That's not true. In old versions of SQL Server a Local Admin group would be added to a MSSQL instance when it's created but not anymore. You need to add it manually.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
@bib92:
Which login is that? It's SA? There's any people with SA privileges in that SQL Server instance?
0
 
bibi92Author Commented:
not sa password login user password.

Thanks
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.