How to reset SA password for SQL 2008?

reset sa password sql 2008Question: I forgot the password of SA account, therefore I don’t be able to login to SQL server 2008
How could I reset SA password SQL 2008?

In the SQL Server 2005 Express I can chose the expert mode during the installation. This enables me to set the password of the user “SA”.
Now I tried to install SQL Server 2008 R2 Express but I had no possibility to change / set the password of the user “SA”.
I read in the internet that the default-password of the user “SA” should be a blank password. Since in SQL Server 2008 R2 Express there was no way to set / reset “SA”’s password I tried to login with a blank password. But this also didn’t work.
Thanks in advance

I have saw many similar problem in SQL forum, so I want to tell you how to reset SA password SQL server 2008 here.

Method 1: Reset SA password SQL server 2008 by Windows Authentication

If Built-in/Administrator is present in SQL 2008 Server, you can login with an ID which is member of Administrators group and reset SA password in SQL Server. Just do as follows:
Step 1. Login into SQL 2008 server using Windows Authentication.
Step 2. In Object Explorer, open Security folder, open Logins folder. Right click on sa account and go to Properties.
Step 3. Type a new SQL SA password, and confirm it. Click OK to finish.

Method 2: Reset SQL server 2008 password with SQL Password Recovery

Step 1: Download SQL server 2008 password reset software and install it on your computer.
Step 2: Run the software, when see the interface, click Open to load the master .mdf file. All the user names of your SQL Server will be displayed.
Step 3: Select the password forgotten account, here the forgotten password account is SA, select it.
Step 4: Click “Change Password” button, then choose the new password in the “Change Password” panel, and then click OK to finish modification.

Method 3: Using Other SQL Server login to Reset SQL 2008 password

If there is any other SQL Server 2008 Login that is a member of sysadmin role, you can log in using that account and reset the password. Recover SA password account as described here :

  • Login into SQL Server using Windows Authentication.
    In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
  • Then type a new SA password, and confirm it. Click OK.

It’s very easy, isn’t it? Now if you forgot SQL 2008 password, you can see the article, it helps you well.

Tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *