Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 3 down vote accepted

You mentioned that you used local accounts for SQL, which is fine, but the SharePoint Setup and Server Farm accounts must be domain accounts, or SharePoint will not be able to talk to the domain which will hamper your ability to add AD users. The following guide on TechNet covers the specifics of installing Office SharePoint Server 2007 with least privilege administration:

share|improve this answer
Just what I was looking for – Elijah Glover Dec 7 '09 at 1:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.