Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Enforce Password Policy and Expiration. When?

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2010-06-16 : 06:24:16
Hello,

When should I use "Enforce Password Policy" and "Enforce Password Expiration" on a SQL Login?

I know that there is another option "User must change password at next login" but this one I always leave unchecked.

Thank You,
Miguel

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-06-16 : 09:29:31
What do you mean? If you want to use it you use and if you don't just leave it as it is. It's just a matter of deciding what your business rules allow... A place to start could maybe be to enforce password policy for end user accounts (if you have them in your database) while service accounts are left out?

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -