Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2010
    Location
    texas
    Posts
    5

    Unanswered: How to reset lost sql sa password?

    Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed to find some good methods to solve the problem. What annoying and terrible experience it is! In order to avoid reinstalling SQL Server for a second time, i collect some methods and try them by myself, to reset SQL Server Password for sa account.

    Method 1: Reset SQL Server sa password by Windows Authentication

    If Builtin/Administrator is present in SQL 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 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.

    This way is easilily to reset the sql server sa or other account password, but you need to have the valid Builtin/Administrator account.

  2. #2
    Join Date
    Sep 2010
    Location
    texas
    Posts
    5

    How to reset lost sql sa password?

    And here is another way that maybe also could reset ours lost sa password, but i have problems to verify this way, can somebody give some ideas about the method.

    Method 2: Use the Query Windows in Management Studio to reset sql sa password

    Step 1. Open SQL Server Management Studio
    Step 2. Open a new query
    Step 3. Type the follow commands and excute:

    Code:
    GO
          ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
          GO
          USE [master]
          GO
          ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
          GO
    The NewPassword is set for your SQL Server sa account.

  3. #3
    Join Date
    Sep 2010
    Location
    texas
    Posts
    5

    How to reset lost sql sa password?

    Use command prompt is also an easy way to reset lost sa password. See the commands below:

    Method 3: Use Command Prompt to reset your lost SQL sa password

    Step 1. Open a command prompt (Start -> Run -> cmd)
    Step 2. Type the follow commands, and press Enter after each line:
    Code:
          Osql -S yourservername -E
          1> EXEC sp_password NULL, 'yourpassword', 'sa'
          2> GO
    Of course, you can reset your other sql account password, just by changing the 'sa' to your another sql account name.

  4. #4
    Join Date
    Sep 2010
    Location
    texas
    Posts
    5

    How to reset lost sql sa password?

    Emm, if there still have trouble on resetting your sql sa password, you can try to get help from some sql server password recovery software, which can easily and instantly reset lost sql sa password.

  5. #5
    Join Date
    Mar 2012
    Posts
    1

    Reset SQL Server Password

    I experienced the same problem a few days ago, later I managed to reset my lost sa password using a software - SQL Server Password Changer, that I found on the internet. Hope it will also be helpful for you!

  6. #6
    Join Date
    Jan 2013
    Posts
    1
    Anyone who uses a 'third party password' changer or resetting tool is acting quite recklessly.

    Do you have the source code? Are you sure that software has no Trojan horses?

    If you use that in my company you would get fired immediately, escorted from the building, and banned from IT forever.

    Script kiddies are the reason IT security costs me so much money!!!
    Last edited by AngryCoder; 01-11-13 at 14:38.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •