How To Reset SA Password On SQL Server
Sign in
  • BLOG
  • Editor's Picks
  • |
  • Technology
  • |
  • Entrepreneurship
  • |
  • Business
  • |
  • Finance
  • |
  • Career
  • |
  • New India
  • |
  • Entertainment
  • |
  • Others

    • How to Reset SA Password on SQL Server

    Jame Bob

    technical support
    The SA account is a built-in administrator login on SQL Server, which has full control over any aspect of SQL Server. It exists in every SQL Server installation no matter which authentication mode you install. Most of the SQL Developers/DBA would have come across a situation that they forgot or lost SA password and have no other way but to reinstall SQL Server database.

    With SQL Server Password Changer (http://www.top-password.com/sql-server-password-recovery.html) you can easily reset lost or forgotten SA password on SQL Server 2000/2005/2008, get instant control over locked databases no matter how many instances of Microsoft SQL Server are running. No need to reinstall SQL Server! Never worry about losing the SA password!

    1. Download and Install SQL Server Password Changer

    1. Click here to download the setup package of SQL Server Password Changer and save it in a place that is easy to find, such as your PC desktop.
    2. When the download is complete, double-click the download file to run the installation wizard. Follow the on-screen instructions to complete the installation.

     

    2. Reset SQL Server Password

    1. Launch the SQL Server Password Changer program.

    2. Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.

      Select the SQL Server master database file

    3. The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the Change Password button. Type a new password and click OK.

      SQL Server Password Recovery

    4. The old password will be replaced with your new password. Now you are able to log into the SA account using your new password.
    start_blog_img