Solved

find forgotten password sql login 2012

Posted on 2014-12-08
6
86 Views
Last Modified: 2014-12-14
hello,

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

Thanks

Regards
0
Comment
Question by:bibi92
6 Comments
 
LVL 32

Expert Comment

by:Big Monty
Comment Utility
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
 
LVL 10

Expert Comment

by:Walter Padrón
Comment Utility
Any member of Local Administrators group can connect to SQL, try to logon using Windows credentials and if successful change the password.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
@bib92:
Which login is that? It's SA? There's any people with SA privileges in that SQL Server instance?
0
 

Author Comment

by:bibi92
Comment Utility
not sa password login user password.

Thanks
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In this previous article (https://oddytee.wordpress.com/2016/05/05/provision-new-office-365-user-and-mailbox-from-exchange-hybrid-via-powershell/), we made basic license assignments to users in O365. When I say basic, the method is the simplest way …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now