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...
>>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.
>

password expiration

How do we enable password expiration on sql 2005. Just upgraded.It's enabled on the server by default - but only supported
on Windows 2003.
You set the expiration on a per login basis - it's not
server-wide setting. So you set it for any SQL Login.
For password expiration, you also need to turn on
CHECK_POLICY (or the Enforce Password Policy option if using
the GUI.
You can find more information in the help topic on Password
Policy:
http://msdn2.microsoft.com/en-us/library/ms161959.aspx
-Sue
On Wed, 21 Mar 2007 10:19:03 -0700, deseotu5
<deseotu5@.discussions.microsoft.com> wrote:

>How do we enable password expiration on sql 2005. Just upgraded.|||Also, it will take the settings of the server if it is enabled. In other
words, in the case where there's not a domain policy, it'll use the password
policies set for the local security policy of the server. Otherwise it'll
use the domain policy.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/
[vbcol=seagreen]
> It's enabled on the server by default - but only supported
> on Windows 2003.
> You set the expiration on a per login basis - it's not
> server-wide setting. So you set it for any SQL Login.
> For password expiration, you also need to turn on
> CHECK_POLICY (or the Enforce Password Policy option if using
> the GUI.
> You can find more information in the help topic on Password
> Policy:
> http://msdn2.microsoft.com/en-us/library/ms161959.aspx
> -Sue
> On Wed, 21 Mar 2007 10:19:03 -0700, deseotu5
> <deseotu5@.discussions.microsoft.com> wrote: