locked
Password policy set RRS feed

  • Question

  • Hi,

    I want to set password policy for all logins.

    In sybase we can use sp_passwordpolicy

    sp_passwordpolicy {“set” | “clear” | “list”}, policy_option, option_value

    If we enable this, it will applicable to all logins, whioh we will create in future, no need to enable individual.

    Is there any option in sql server?


    Shashikala

    Thursday, March 6, 2014 9:12 AM

Answers

  • Hi,

    I want to set password policy for all logins.

    In sybase we can use sp_passwordpolicy

    sp_passwordpolicy {“set” | “clear” | “list”}, policy_option, option_value

    If we enable this, it will applicable to all logins, whioh we will create in future, no need to enable individual.

    Is there any option in sql server?


    Shashikala

    SQL Server can use Windows password policy mechanisms, please refer below article how to enforce it.

    http://technet.microsoft.com/en-us/library/ms161959.aspx


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    • Marked as answer by bhat BK Thursday, March 6, 2014 10:23 AM
    Thursday, March 6, 2014 9:20 AM