SA Password change for SQL

5 pts.
Tags:
SA password
SQL 2005
SQL 2005 admin
SQL 2005 SP3
 What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?

Software/Hardware used:
SQL 2005 SP3

Answer Wiki

Thanks. We'll let you know when a new response is added.

Password changes are done via the sp_password system stored procedure.

<pre>exec sp_password ‘sa’, ‘YourNewPassword’</pre>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kevin Beaver
    You can always use a cracking tool such as SQLPing3 to test its strength. But that's only going to be as good as the dictionary you use. Also, make sure your SQL Server system is patched and no drives are improperly shared. If someone can gain access to master.mdf they can use Elcomsoft's Advanced SQL Password Recovery to access/change it.
    16,610 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following