locked
Settting password expiry to login/users without domain policy dependency RRS feed

  • Question

  • Hi Friends,

    I would require your help,in setting password expiry for login/users.But this shouldnt have any dependency with Windows Domain users expiry policy.For example our domain user expiry policy 45 days but we want sql server login/users password expiry to be 180days.For any clarifications

     Regards

     vijay

     

    Saturday, November 27, 2010 7:17 AM

Answers

  • Hi Vijay,

    The Password policy is dependednt on the Local Server / Domain Password policy. More information here. I don't think it is possible to define password policy for SQL logins without the dependency on Windows settings.




    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    Saturday, November 27, 2010 10:13 AM

All replies

  •  

    Hi,

    Just add to the same i am using sql 2005.

    Regards

    Vijay

    Saturday, November 27, 2010 7:22 AM
  • Hi Vijay,

    The Password policy is dependednt on the Local Server / Domain Password policy. More information here. I don't think it is possible to define password policy for SQL logins without the dependency on Windows settings.




    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    Saturday, November 27, 2010 10:13 AM