disable sql 2005 mixed mode password complexity?

I installed SQL Server 2005 for the first time today, and I set it to
mixed mode because that is how we have always had to configure 2000 in
the past for certain applications. I used a weak password for the sa
account, and it caught that, so I changed it.
The problem came when I attempted to install some applications that
previously worked under SQL Server 2000. The first one installed
without errors, but when I attempted to login, there was a connection
error and it said that the database login (which it creates during
install) was invalid. I set the connection properties to use the sa
login, and that worked (as this is a demo, I'm not particularly
concerned with security at the moment).
The next application I attempted to install actually errored out on me,
with some timeout error. When I tried to launch it after the failed
install, I again get connection errors. When I looked at the user
accounts in the Enterprise Manager-like addin (I forget what it's
called), I didn't see any of the accounts which should have been
created during the setup of either application.
Please let me know if I'm way off base here, but what seems to be
happening is that the applications I'm installing use weak passwords
for the SQL user accounts they configure, so they never get created.
Since the accounts are created by an installer, I have no control over
what password they use. So I just need to know if there's some way I
can disable the password complexity check for new accounts and get this
software installed. I'll lecture the developers on security later.You can modify Windows security policy that disable password policy.
"bcochranmsa@.gmail.com"?? ??? ??:

> I installed SQL Server 2005 for the first time today, and I set it to
> mixed mode because that is how we have always had to configure 2000 in
> the past for certain applications. I used a weak password for the sa
> account, and it caught that, so I changed it.
> The problem came when I attempted to install some applications that
> previously worked under SQL Server 2000. The first one installed
> without errors, but when I attempted to login, there was a connection
> error and it said that the database login (which it creates during
> install) was invalid. I set the connection properties to use the sa
> login, and that worked (as this is a demo, I'm not particularly
> concerned with security at the moment).
> The next application I attempted to install actually errored out on me,
> with some timeout error. When I tried to launch it after the failed
> install, I again get connection errors. When I looked at the user
> accounts in the Enterprise Manager-like addin (I forget what it's
> called), I didn't see any of the accounts which should have been
> created during the setup of either application.
> Please let me know if I'm way off base here, but what seems to be
> happening is that the applications I'm installing use weak passwords
> for the SQL user accounts they configure, so they never get created.
> Since the accounts are created by an installer, I have no control over
> what password they use. So I just need to know if there's some way I
> can disable the password complexity check for new accounts and get this
> software installed. I'll lecture the developers on security later.
>|||ALTER LOGIN Username
SET CHECK_POLICY = OFF

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