Alpha is a newly hired graphic artist in your company. She owns an Apple laptop on which she wants to perform graphical work. Alpha also has a need to access some data in the corporate database. You have an Activce Directory domain named BigCompany.com in use and Windows Authentication mode is set for SQL Server. How can Alpha’s request for access be accomplished?

Alpha is a newly hired graphic artist in your company. She owns an Apple laptop on which she wants to perform graphical work. Alpha also has a need to access some data in the corporate database. You have an Activce Directory domain named BigCompany.com in use and Windows Authentication mode is set for SQL Server. How can Alpha’s request for access be accomplished?


Answer: – This situation is somewhat more complex and the above answers are inadequate.

(An Apple user cannot normally be connected to an Active Directory domain as the Apple device cannot be joined to the domain. Thus while an Active Directory user can be set up, the user cannot use it with the Apple device. With Windows authentication, a Windows user is required. If the SQL Server instance was changed to use Mixed mode authentication, then Alpha could connect from the Apple laptop to SQL Server. That change however may not be something that should be done to accommodate a single user.)