How to reset SQL Server sa password using Microsoft SQL Server Management Studio

1. Reset the SQL system administrator password

a)  Download and install Microsoft SQL Server Management Studio Express; Make sure to choose the suitable Windows platform (x86 or x64);

b)  Open the application, and choose the authentication mode:  “Windows Authentication”;

 

c)  Press “Connect” button and navigate to the Security->Logins folder in the left side of your window; Right-click on “sa” and choose properties;

d)      Change the password with a complex one.   For e.g.: P@ssw0rd;

e)  Make sure that SQL Server allows the “sa” account to connect and has enough permissions; Navigate to Status-> and choose “Grant” and “Enabled” in the right side of the window.