You have numerous clients on your network that need access to the SQL Server. Many of these run Unix with Samba, which allows them to use an Active Directory account to access resources on the Windows domain. Several others use Mac clients with the AppleTalk protocol for accessing the network. The remaining clients are Windows Vista and XP Professional clients. Which authentication mode setting should you select when installing SQL Server?

You have numerous clients on your network that need access to the SQL Server. Many of these run Unix with Samba, which allows them to use an Active Directory account to access resources on the Windows domain. Several others use Mac clients with the AppleTalk protocol for accessing the network. The remaining clients are Windows Vista and XP Professional clients. Which authentication mode setting should you select when installing SQL Server?

You have numerous clients on your network that need access to the SQL Server. Many of these run Unix with Samba, which allows them to use an Active Directory account to access resources on the Windows domain. Several others use Mac clients with the AppleTalk protocol for accessing the network. The remaining clients are Windows Vista and XP Professional clients. Which authentication mode setting should you select when installing SQL Server?


Answer – Mixed Mode

(Your Mac clients will not be able to access SQL Server when you select Windows Authentication Mode, because they do not have Windows domain accounts, so you need to select Mixed Mode.)