Re: Password complexity in SQL
- From: "Bob Beauchemin" <bobb_no_spam@xxxxxxxxxxxxx>
- Date: Wed, 24 Jan 2007 09:07:20 -0800
Not for SQL Server 2000 not I'm aware of, unless you build and enfore this
functionality yourself. In SQL Server 2005, SQL passwords will abide by the
Windows OS machine/domain password policy with Windows Server 2003 and
above. In either version, its preferred to use only Windows logins which
have had password complexity policies for some time. Do you really need to
support SQL logins?
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Rockitman" <Rockitman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8F93457A-538A-4FD5-8551-79A9404AB777@xxxxxxxxxxxxxxxx
We have a SQL 2000 server and a client app that accesses it. We utilize
SQL
authentication for the users who have already logged into the Windows
domain
with a separate userid and password.
We are currently going through a certification and accredidation test and
one of the things we are getting dinged on is that we do not require
complex
passwords with the SQL password. I see nowhere in SQL server to setup
mandatory password complexities, ie: minimum 8 characters, at least 1
number, 1 capital letter, etc.
Is there somewhere in SQL 2000 that a password policy for the SQL password
can be setup?
.
- Prev by Date: Re: Trouble with linked servers
- Next by Date: Re: Password complexity in SQL
- Previous by thread: Trouble with linked servers
- Next by thread: Re: Password complexity in SQL
- Index(es):
Relevant Pages
|
|
