[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

find forgotten password sql login 2012

hello,

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

Thanks

Regards
0
bibi92
Asked:
bibi92
1 Solution
 
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
 
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now