Password policy for SQL Server

  • Hi,

    I would like to force an application to change it's SQL Server account password every 12 months. It looks like SQL Server can enforce Windows password policy but the Windows password policy that comes from the domain requires a password change every month or two.

    Can I create a new policy with an annual password rotation requirement and then tell SQL Server to enforce that policy instead of the one from the domain?

    Thanks for reading.

    Howard

  • Hi, Unfortunately you are not able to do this in SQL Server.

    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com
  • Thank you for the reply.

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

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