I am trying to install a single server SharePoint farm (connected to the domain), using Microsoft SQL Standard 2005. Active Directory resides on a different server.
As i am using the principle of least privilege, I have setup some local accounts for SQL and file permissions (working fine).
The problem that I am having is I can't add an active directory users as a site collection administrators in the UI, only local users.
Do I need to setup the farm using an Active Directory User? To get access to querying Active Directory Users?