Thursday, July 7, 2016

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.




 

No comments:

Post a Comment