Documentation Index

Fetch the complete documentation index at: https://kb.pharos.com/llms.txt

Use this file to discover all available pages before exploring further.

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

Prev Next

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