SQL Server 2005 provides rich security features to protect data and network resources. By default, client-server communications are even encrypted. SQL Server 2005 supports encryption capabilities within the database itself, fully integrated with a key management infrastructure.
The built in encryption of data ensures that confidential information is secure in case of a physical compromise or otherwise unauthorized access to the database system. Data can be encrypted without having to modify applications by using Transparent Data Encryption.
The following are some security features in SQL Server:
- Password Policy Enforcement
- Built In Encryption and Key Management
- Security Role Based Data Access
- User Security Groups
- Users Need to be Given Access To Data
- Enhanced Auditing Features