password sql 2005

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 meet
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 meet
> 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 meet
> windows policy requirenments because it is too short.
> In sql 2005 is the password policy based on your windwows policy?