password sql 2005

I am creating an db login called test to test some sripts. When I try to se
t
that password it says password validation failed. The password does not mee
t
windows policy requirenments because it is too short.
In sql 2005 is the password policy based on your windwows policy?stoney wrote:
> I am creating an db login called test to test some sripts. When I try to
set
> that password it says password validation failed. The password does not m
eet
> windows policy requirenments because it is too short.
> In sql 2005 is the password policy based on your windwows policy?
>
It can be, but doesn't HAVE to be. Study the options that are available
when you create a new login.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I think that this is the behvior if the OS is windows 2003. In any
case you can use the option CHECK_POLICY = OFF when you create the
login. Here is an example:
CREATE LOGIN MyLogin WITH PASSWORD = 'MyPass', CHECK_POLICY = OFF
Adi
stoney wrote:
> I am creating an db login called test to test some sripts. When I try to
set
> that password it says password validation failed. The password does not m
eet
> windows policy requirenments because it is too short.
> In sql 2005 is the password policy based on your windwows policy?