TABLE OF CONTENTS By the end of this chapter, you should have a good understanding of password policies and how they integrate with the underlying operating system. We ll cover not only how to set password policies in SQL server, but also why. You ll see by example how to create and administer password policies.
You ll also gain an understanding of how group policy works in Microsoft Windows, and the impact of changes you make to group policy on the underlying operating system.
Password polices are a new feature in SQL Server 2005. So what are password policies? They are a series of rules enforced to ensure passwords in SQL server follow standards set forth in the operating system via group policy.
Password policies can be turned off and on in SQL server. There may be reasons for not using password policies overall, or just on specific accounts.
Password polices force the account to adhere to a specific set of rules. The rules can be broken down into two distinct types, one set of rules related to password policies, and another related to account lockout policies. The following sections detail each of these policies.
| Some Independent Advice | Since group policies are usually controlled by the network administration group in most organizations, be sure to communicate with the appropriate teams in your organization before making any changes. |
The easiest way to use the group policy console is to start the management...
