Authentication Modes in SQL Server 2008

Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization's databases.

Read the full article: Choosing a SQL Server Authentication Mode