Link to home
Start Free TrialLog in
Avatar of paul_brinkman
paul_brinkman

asked on

Change an Existing sa password

We have had to upgrade from MSDE to SQL 2005 Express.  I am unable to restore the data because of an install goof by our developers.  I need to change the sa password.  I have the old password, and I have the new password. but I don't know how to change the sa password to finish this upgrade.  
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

check out the sp_password procedure.
Change a password
This example changes the password for the login Victoria from ok to coffee.

EXEC sp_password 'ok', 'coffee'
Avatar of Pawel Lijewski
Pawel Lijewski

sp_password returns: Cannot alter the login 'sa', because it does not exist or you do not have permission.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sorry typo


sp_Password @Old = 'putOldPassword', @New = 'newpassword', @loginame ='sa'
what if you don't have old_password ?
it is not necessary that you need the old passoword in the above part

You just need to provide the  @New and @loginaname
So you've sorted it all out now?