October 5, 2009 at 5:09 am
It is possible to set on server level on login creation to always ask for strong password.
October 5, 2009 at 5:21 am
radica_pet (10/5/2009)
It is possible to set on server level on login creation to always ask for strong password.
depends on your windows server setting, from the sql server point of view. if 'enforce password policy' is set, it will use what has been set up at the windows server level
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 5, 2009 at 7:05 am
Yes, thanks.
But how can I "enforce password policy"?
Where can I manage this?
October 5, 2009 at 9:40 am
Forcing users to set strong passwords is determined (in and Active Directory Domain) at the Domain Controller. If you have access to your Domain Controller then you can set the OU (Organizational Unit) Group Policy to require users to use a strong password.
Then in SQL you simply check the "enforce Password Policy"
Normally there are network admins that set the OU settings. If you need to you may need to work with them in order to set a password policy. However unless you have an OU just for your servers, the password policy will push down to all desktop users as well.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply