December 25, 2008 at 3:17 pm
Hi,
when i create new sql logins by default this user gets the three policy logins (enforce password and user must change password).
is there a way to disable this on the server side that every time that i create new sql logins those three option will be unmarked?
THX
December 30, 2008 at 1:18 am
The policy is applicable for SQL Server Logins. Microsoft recommends not to turn of the password policy. As documented in BOL, "Turning off this option may result in a security risk."
If you want to turn it off for the existing logins you can write a cursor or generate ALTER statment for with CHECK_POLICY = OFF.
If you want to disable it on the server level, you can add trace flag 4602 while starting up the SQL Server to disable this option, which is not recomended. You can find some more details in the below KB article.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;936892
r, manish
December 30, 2008 at 8:08 am
THX.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply