Check_Policy - Check_Expiration
Sep 19, 2007Is there any way to turn off the CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF so that all the accts. created can be created through the management console without checking either of these?
Thanks,
R /p
ADVERTISEMENT
Password History With CHECK_POLICY And CHECK_EXPIRATION
Sep 11, 2006I've tried to find a definitive answer to this but I cannot. If CHECK_POLICY = ON and CHECK_EXPIRATION = ON will password history be checked when a user changes their password? By password history I mean the idea that a password once used cannot be used again for another X password resets....
If password history does work, why would executing the following statement multiple times then work?
ALTER LOGIN Bob WITH Password = '123User321'
If I execute this statement four times in a row wouldn't I get a message that I cannot reuse the password on the second call?
Thanks in advance
Need Sp_addlogin With CHECK_POLICY = OFF
Jul 17, 2006Hi
We are using SQL Server-2005 as backend,
i had code like,
sp_addlogin 'a', 'a'
this give error as
"Password validation failed. The password does not meet Windows policy requirements because it is not complex enough"
as this is not full fill the Windows Password policy.
I too check the Local Security Settings is disable for the password settings.
I know i can use
CREATE USER <user> , CHECK_POLICY =OFF
but i want to set CHECK_POLICY =OFF, with the
sp_addlogin stored Procedure.
Any help,hint or code to solve this ???
Regards,
Thanks.
Gurpreet S. Gill
SQL Login CHECK_POLICY Calculations
Sep 20, 2007Hi.... I'm querying for SQL -logins whose passwords are about to expire.
If Active Directory has a password expiration policy of x days, which is the correct query to use?
SELECT name, DateAdd(day, x, create_date) FROM sys.sql_logins WHERE is_expiration_checked = 1
or
SELECT name, DateAdd(day, x, modify_date) FROM sys.sql_logins WHERE is_expiration_checked = 1
Or is this stored elsewhere from sys.sql_logins?Thanks.