password policy

I tried to unchecked the password policy for a user. But I got an error
message when I press the OK button, "CHeck policy and check expiration
cannot be off when must change is on". Can anyone please tell me where I can
turnoff the must_change option so that I can uncheck the password policy.
THanks.
I am using SQL 2005 server.
" 00EricClapton" <EE@.yahoo.com> wrote in message
news:e4RjS01aHHA.4396@.TK2MSFTNGP06.phx.gbl...
>I tried to unchecked the password policy for a user. But I got an error
>message when I press the OK button, "CHeck policy and check expiration
>cannot be off when must change is on". Can anyone please tell me where I
>can turnoff the must_change option so that I can uncheck the password
>policy. THanks.
>
|||Hello,
Best option is login using that user and change the password once it prompts
for a password and then disconnect. After that connect as SA and uncheck the
password policy.
This will work.
Thanks
Hari
" 00EricClapton" <EE@.yahoo.com> wrote in message
news:OfOPL41aHHA.4220@.TK2MSFTNGP03.phx.gbl...
>I am using SQL 2005 server.
>
> " 00EricClapton" <EE@.yahoo.com> wrote in message
> news:e4RjS01aHHA.4396@.TK2MSFTNGP06.phx.gbl...
>