When you are installing SQL Server 2008, you are asked to specify which authentication mode SQL Server will use when the setup finishes. There are only two options: 1. Windows Authentication Mode You can use only a Windows user account to logon to SQL
