How do I change the SA password and turn off the SQL security policy in SQL 2005?
  • 02 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

How do I change the SA password and turn off the SQL security policy in SQL 2005?

  • Dark
    Light
  • PDF

Article summary

How do I change the SA password and turn off the SQL security policy in SQL 2005 using OSQL?


C:\Documents and Settings\Administrator>osql -E -S.

1> ALTER LOGIN sa WITH CHECK_POLICY = OFF
2> go
1> exec sp_password NULL, 'pharos', 'sa'
2> go


Was this article helpful?


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.