January 8, 2010 at 2:50 pm
How do I set custom complexity requirements for setting new SQL Server passwords?
I need at least 14 characters, and min of: 2 uppercase, 2 lowercase, 2 special ch., 2 numbers.
Does this need to be scripted? I'm running SS2005 SP3 9.00.4266.
Thanks,
Fred Z.
Atlanta, GA
January 8, 2010 at 3:00 pm
Check out this article.
http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102101,00.html
With the new SQL Server 2005 security features, SQL Server logins will have all the same security policy features available. Both SQL Server users and application roles will use the policy. With Windows Server 2003 or later, the policy will be implemented via an OS-level call, Net ValidatePasswordPolicy, so that the administrator can use the same policy for both Windows integrated and SQL Server logins. To give companies that convert to SQL Server 2005 time to analyze how the policy will affect existing applications, the policy can be turned off on a per-login basis. Obviously, this is not recommended. As Windows provides users with the ability to change their password at login time (or while logged on to Windows), so SQL Server users will have the ability to change their password during login. Both the client APIs, like OLE DB and ADO.NET, and the client tools, like SQL Server Management Studio, will support this.
Password policy is set by using the Active Directory Users and Computers tool if you're using Active Directory, or by using the Local Security Settings administrator tool if you're administering a nondomain computer.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 3:01 pm
What version of the Windows OS are you using? If using Windows 2003 and newer, you can use the password policy in AD. There is no setting in SQL Server itself, iirc.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply