Have you ever needed to change or even forgotten the password of the SQL Server System Administrator (SA) account? Maybe the password has been lost or the person in charge of keeping it left the company? In this article I will walk you through three most common ways to change the password and get you back into your SQL SA account.
The first method is to use the current SA password to log into the SQL Server Management Studio and change it. The second method is to use another administrator account to log into the SQL Server Management Studio to reset the password. The third method is to use a command prompt to restart the SQL service in a Single User Mode, reset the password, then restart the SQL service back in Multi-User mode.