Posts Tagged ‘reset SA password’

How to Reset Forgotten SA Password without Stopping SQL Server Instance

November 18th, 2013 by Admin

Forgot your SA password or get locked out of SQL Server? How to connect to SQL Server database in case the ‘BUILTIN\Administrators’ group is removed from SYSADMIN server role? One of my previous articles covers how to recover sa password through single user mode, but that approach requires of restarting your SQL Server instance and causing some downtime. Sometimes this would be unacceptable. In this article we’ll provide you with another way to reset forgotten SA password in SQL Server 2012/2008/2005 without any downtime.

How to Reset Forgotten SA Password without Stopping SQL Server Instance?

  1. To get started, we need to run the SQL Server Management Studio as the system account. This can be done easily with the PsExec program. Download PsExec from Sysinternals website. Extract the PsExec.exe program and save it to a folder on your computer such as C:\.
  2. Open an elevated Command Prompt and run the following command:
    C:\PsExec.exe -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
    Note: Your actual path of SQL Server Management Studio may be different from the one above.
  3. It will start SQL Server Management Studio as the system account. You’ll see that the username is shown as “NT AUTHORITY\SYSTEM”. Simply choose the “Windows Authentication” mode and click on the Connect button.

    connect-to-server

  4. Once you connect, in the Object Explorer view, click the plus sign next to Security, and then the plus sign next to Logins. Once expanded, right-click on the SA user, and choose Properties. You can then change the forgotten SA password with a new one.

    reset-sa-password

It is quite common to get locked out of a SQL Server instance, or simply forgot the SA password. With this approach you can reset forgotten SQL Server password easily! Quickly regain access to your SQL Server database without even any downtime.

How to Reset Forgotten SA Password in SQL Server 2008

May 29th, 2013 by Admin

I installed SQL Server 2008 sometime ago and forgot the sa password I set during setup. How can I connect to SQL server now? Is there a way I can retrieve sa password in SQL Server 2008?

If you ever forgot a SA password, you may have thought that the only option is to reinstall SQL Server. But this is not true. If you can still log in to your SQL Server with Windows authentication mode, or log in using other user account that is a member of sysadmin role, then you can reset the lost SA password easily! However I don’t think this approach will help you, otherwise you wouldn’t be sitting here reading article, would you?

Other method is to use this professional password recovery software – SQL Server Password Changer, which provides you with an easy way to reset forgotten SA password in SQL Server 2008 (R2). It also supports SQL Server 2012/2005/2000. Follow this tutorial and you can reset SQL Server password and regain access to your database easily and quickly.

How to Reset Forgotten SA Password in SQL Server 2008?

  1. Download and install SQL Server Password Changer on your computer.
  2. After installing, start the program and then click on “Open File” button.
  3. It will display a dialog box that prompts you to choose the master.mdf database of your SQL Server. But at this time you need to stop your SQL Server serivce in advance so this password recovery program is able to regain full control over the master.mdf file.
  4. Once you’ve chosen the master.mdf file, click on “Open”. The program will display all user accounts existing in your SQL Server database.

  5. Choose the SA user account and then click on “Change Password” button. Enter your new password and click OK. Now you’ve successfully reset your forgotten SA password in SQL Server 2008.
  6. Start the SQL Server service and then you can log in to the SA account using the new password.

Using SQL Server Password Changer you can also reset the password of any other user accounts existing in your SQL Server 2008 database. Resetting the password of SA is a breeze!