sa password reset

(0) Share

Report

Posted on by SavATree

I need to reset the sa password as it was corrupted.

I followed one of the instructions in this forum to do the following:

You need to do this directly in SQL server management studio under the >Security>Logins. Then Right click on 'sa', click properties, change the password and enter it again to verify.

and I can get all the way through the instructions - click OK. But get an error that says

Change password failed for Login 'sa'. An exception occurred while executing a Transact-SQL statement or batch

Cannot alter the login 'sa' because it does not exist or you do not have permission.

Help!

Categories:

Administration and Setup

All responses (3)

Answers (0)

SavATree 5 on at

Like (1)

Report

RE: sa password reset

Thanks folks - took me a while to find out how to get back to this screen but really appreciate the answers. Turns out that you are correct, I didn't have the right level of security to reset the sa password. But more importantly, it also turns out that I was just entering the wrong password when trying to sign on. Might need a vacation ...... Thanks!
Suggested answer

Bill Campbell 22,647 on at

Like (1)

Report

RE: sa password reset

Altering the 'sa' password is not something just anyone can do. You might be able to go thru the motions as your user ID when connected to SSMS but to actually change the password is reserved to SYSADMIN users.

Just poking my nose into this one.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: sa password reset

You will need to check your settings in your domain for security and make it is strong enough. Also make sure have not disabled the 'sa' account.