Post reply

remove the default user login policy

  • December 25, 2008 at 3:17 pm

    #199395

    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

    #918835

    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

    #919059

    THX.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply