password recovery studio

PASSWORD UNLOCKER

Password Reset and Password Recovery Tools

How to Change SA Password When You Forgot It?

Thursday, 5. January 2012

Due to the full rights of SA login in SQL Server, it is imperative to change SA password on a regular basis whether it is monthly, quarterly or semi-annually.  Changing SA password is a relatively easy process, having no impact on the organization.  Unfortunately, changing SA password on a regular basis is not a common practice at most organizations. Then how to change SA password? There are 2 methods to follow:

Method 1: Change SQL Server login password by its properties

If you can logon to SQL Server, just do as follows:

  • 1. Login into SQL server.
  • 2. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
  • 3. Type a new SQL SA password, and confirm it. Click OK to finish.

After restarting SQL Server and all its services, you can log into SQL Server by SA login with new SQL SA password. Read more