Knowledgebase
How to change SQL Server “sa” password?
Posted by on 29 October 2012 11:26 PM

To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command: 

SP_PASSWORD @NEW = 'new_password', @loginame = 'sa' 

After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.

Updated: 11-01-2011
If you receive the foloowing error:
Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.

Have a look at the follwoing article from Microsoft: http://tinyurl.com/72ayqrn


(3 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).