The Multifunctioning DBA

Aug 27 2011   9:00AM GMT

SQL Server Accounts password policies

Colin Smith Colin Smith Profile: Colin Smith

When creating a SQL Server level account and not using windows authentication, how do you set things up so that you know you have a complex password that meets your requirments? Well that is what the is_policy_checked option is for. If that is set = 1 then SQL Server will read your password policy from the local security policy or the domain policy and enforce those same restrictions on the password. Restrictions are password length and complexity, password history and things like that. But I also need the passwords never to expire. these are accounts that applications use and if the passwords expire then that could cause a big mess when the application can no longer log into the database. Well that is why the put the is_expiration_checked option in as well. Both options are turned off by default but if you select the policy option then the default for expiration also becomes checked so if you do not want it to expire you need to make sure to uncheck that option after you turn on the policy. So if you do not check the expiration then the policy still gets checked but it does not apply the section of your security policy about expiration to the sql auth accounts.

Hope that makes sense and helps you out. Here is a link to BOL about this as well.

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

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: