Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
liffey
Yak Posting Veteran
58 Posts |
 Posted - 2006-09-28 : 13:04:14
|
| SQL 2005 running on Win2K3I add a new user and select SQL Server Authentication. When I attempt to connect to the db (testing connection with ODBC for SQL) I get an error stating "The Password of the account must be changed".If I uncheck Enforce Password Policy SQL gives me an error:"The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON"How do I turn off "MUST_CHANGE"?Declan-dw |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-28 : 13:52:09
|
This should work although I can't test it right nowALTER LOGIN TestLogin WITH PASSWORD = 'newpassword',CHECK_POLICY = OFF,CHECK_EXPIRATION = OFF |
 |
|
|
|
|
|
Password must be changed