September 12, 2014

SQL Database in Recovery after SA Password Locked Out

Locked out of SQL Server because of SA password locked out, and couldn’t login SQL Server with Windows Authentication mode? What can we do to make SQL database recovery or password recovery?

Once SQL database recovery is mentioned, something always impresses us. Whenever you bring a database online, SQL Server goes through a recovery process. It seems to be boring if we want to access SQL database instantly at that moment.

However, if SA password has been locked out, we could make SQL database in recovery to reset SA password. And then login into SQL Server with new SA password. All these just need a tool, SQL Password Genius.

SQL Password Genius is a powerful tool to reset user password for SQL database in few seconds. No matter it is SA or other users with different privileges, just select it in SQL Password Genius and, click "Reset" button, it could be set with new password.

Now let’s go to see how this SQL password recovery tool makes SQL database/password recovery successful. This way applies to SQL Server all versions, including SQL Server 2014.

Precondition: SQL master database, SQL Password Genius, accessible computer with admin privileges.

Process of SQL Database in Recovery with Tool

1. Install SQL Password Genius (full version) on accessible computer.

This computer has been installed with Microsoft SQL Server 2000/2005/2008/2012/2014. And SQL master database can be found.

Why we take full version? Because trial version only could import master database, but still could not reset password for database recovery.

2. Browse master database in computer and import it into tool.

By clicking "Open File" button in tool, you would access to computer and could browse SQL master database in computer. When you find it, click "Open" button to import it into SQL Password Genius.

3. Recover SQL Server Master Database.

As soon as master database is imported, all of its users for it also appear in this tool.

How to recover SQL master database and make it accessible? Just select user, general SA account in user list, and click "Reset" button to type new login password for SA. Master database file is also recovered at the same time.  Its logon user, SA password has changed.

Related Articles:

No comments:

Post a Comment