Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1500
  • Last Modified:

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.  
0
paul_brinkman
Asked:
paul_brinkman
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
check out the sp_password procedure.
0
 
James MurrellProduct SpecialistCommented:
Change a password
This example changes the password for the login Victoria from ok to coffee.

EXEC sp_password 'ok', 'coffee'
0
 
Pawel LijewskiCommented:
sp_password returns: Cannot alter the login 'sa', because it does not exist or you do not have permission.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Aneesh RetnakaranDatabase AdministratorCommented:
sp_Password @Old = 'putOldPassword', @Nen = 'newpassword', @loginame ='sa'
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
sorry typo


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

You just need to provide the  @New and @loginaname
0
 
James MurrellProduct SpecialistCommented:
So you've sorted it all out now?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now