Security Features in SQL Server 2005 for the Developer
In this tutorial you will learn about Security Features in SQL Server 2005 - Authentication, Password Complexity, Password Expiration, Lockout Behavior, Endpoint-based Authentication, Authorization, Native Data Encryption, Code and Module Signing, SQL Server Agent Operations, Monitoring and Auditing
Authentication
SQL server has been designed to be “secure by default”. However, it has a number of customizable features that further increase the degree of protection—Authentication, Authorization and encryption. The settings have been optimized and avoid installing non essential components and features that can expose the server and its data to attacks.
It uses mixed and windows authentication modes though Windows Authentication is the preferred mode.
Read
More...
http://www.exforsys.com/content/view/1702/356/