Microsoft SQL Server 2008, the latest release version of SQL Server, is a full-featured relational database management system that provides different sorts of administrative tools to relief the burdens of database development, maintenance and administration.

SQL Server 2008 offers administrators two types validation and authentication for access link to resources database, that is: Windows authentication mode and mixed authentication mode (SQL Server and Windows authentication mode). Both of these authentication methods provide access to SQL Server 2008 and its resources.

SQL Server and Windows Authentication Mode apply either Active Directory user accounts or SQL Server accounts as validating access to SQL Server. SQL Server 2008 introduces the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. The policies of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode...