disable PERMANENTLY password policy check

How do I force SQL Server 2005 (on windows 2003) NOT to check password
policy?
On Feb 14, 7:13 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Create the login using the proper options:
> CHECK_POLICY = { ON | OFF}
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>
> <ret...@.gmail.com> wrote in messagenews:1171468074.706539.231460@.j27g2000cwj.g ooglegroups.com...
> - Show quoted text -
The default for CHECK_POLICY is ON, I want to switch the default to
OFF.
|||On Feb 15, 11:47 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I see. I don't think you can change the default, though...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
Hi Tibor, thanks!

disable PERMANENTLY password policy check

How do I force SQL Server 2005 (on windows 2003) NOT to check password
policy?Create the login using the proper options:
CHECK_POLICY = { ON | OFF}
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<retima@.gmail.com> wrote in message news:1171468074.706539.231460@.j27g2000cwj.googlegroups.c
om...
> How do I force SQL Server 2005 (on windows 2003) NOT to check password
> policy?
>|||On Feb 14, 7:13 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Create the login using the proper options:
> CHECK_POLICY = { ON | OFF}
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://sqlblog.com/blogs/tibor_karaszi
>
> <ret...@.gmail.com> wrote in messagenews:1171468074.706539.231460@.j27g2000c
wj.googlegroups.com...
> - Show quoted text -
The default for CHECK_POLICY is ON, I want to switch the default to
OFF.|||> The default for CHECK_POLICY is ON, I want to switch the default to
> OFF.
I see. I don't think you can change the default, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<retima@.gmail.com> wrote in message news:1171528624.564832.64110@.q2g2000cwa.googlegroups.com
..
> On Feb 14, 7:13 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> The default for CHECK_POLICY is ON, I want to switch the default to
> OFF.
>|||On Feb 15, 11:47 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I see. I don't think you can change the default, though...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sq
lblog.com/blogs/tibor_karaszi
Hi Tibor, thanks!

disable PERMANENTLY password policy check

How do I force SQL Server 2005 (on windows 2003) NOT to check password
policy?Create the login using the proper options:
CHECK_POLICY = { ON | OFF}
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<retima@.gmail.com> wrote in message news:1171468074.706539.231460@.j27g2000cwj.googlegroups.com...
> How do I force SQL Server 2005 (on windows 2003) NOT to check password
> policy?
>|||On Feb 14, 7:13 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Create the login using the proper options:
> CHECK_POLICY = { ON | OFF}
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>
> <ret...@.gmail.com> wrote in messagenews:1171468074.706539.231460@.j27g2000cwj.googlegroups.com...
> > How do I force SQL Server 2005 (on windows 2003) NOT to check password
> > policy... Hide quoted text -
> - Show quoted text -
The default for CHECK_POLICY is ON, I want to switch the default to
OFF.|||> The default for CHECK_POLICY is ON, I want to switch the default to
> OFF.
I see. I don't think you can change the default, though...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<retima@.gmail.com> wrote in message news:1171528624.564832.64110@.q2g2000cwa.googlegroups.com...
> On Feb 14, 7:13 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Create the login using the proper options:
>> CHECK_POLICY = { ON | OFF}
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>>
>> <ret...@.gmail.com> wrote in messagenews:1171468074.706539.231460@.j27g2000cwj.googlegroups.com...
>> > How do I force SQL Server 2005 (on windows 2003) NOT to check password
>> > policy... Hide quoted text -
>> - Show quoted text -
> The default for CHECK_POLICY is ON, I want to switch the default to
> OFF.
>|||On Feb 15, 11:47 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > The default for CHECK_POLICY is ON, I want to switch the default to
> > OFF.
> I see. I don't think you can change the default, though...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
Hi Tibor, thanks!

Disable password policy enforcement SQL server 2005

Is there a way to do this at the server level?

Thanks

No, there is no global switch to turn on or off this protection.

Thanks
Laurentiu

|||

I guess yes there is you have to open the Local Security settings using the mmc plugin and disable the Enforcements of policy settings like complexity etc. and you should be done.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Yes, but then you would disable the policy enforcement at the OS level, not at SQL Server level.

Thanks
Laurentiu