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!
