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

You have a variety of options for updating the SQL Server Agent password on the clients. The method you specify depends on the tools available on the client computer.

If the SQL Server Enterprise Manager is available on the client computer, you can change the sa password directly. For details, follow the procedure in Changing sa Password on the Server. Read more

With the rights that the sa login has by default in SQL Server, it is imperative to change this password on a regular basis whether it is monthly, quarterly or semi-annually.  In addition, as DBAs move on to other opportunities, it is wise to change the sa password as well.  Changing the sa password should be a relatively easy process requiring little to no impact on the organization.  Unfortunately, changing the sa password on a regular basis is not a common practice at most organizations, because the impacts of changing the password are unknown. Read more