SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Understanding Authentication Authentication is the process used to validate a user or system identity. Strong authentication systems include both secure storage of credentials and secure validation processes. SQL Server supports strong authentication methods.

SQL Server Authentication Methods SQL Server allows both Windows authentication and internal SQL Server authentication. SQL logins are processed by SQL Server internally and should be processed across secure channels that use encryption. Windows logins are processed by the Windows domain or the local Windows server and are passed through the SQL Server. Windows logins are considered more secure.

Logins, Users, and Roles Logins are created using the CREATE LOGIN T-SQL command ...