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!
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!
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148