Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

We are students and we have to make a project by using SharePoint.

We have already learned the basic steps of SharePoint 2010 but now we have some problems with using the Active Directory. We've deleted SharePoint from the server and afterwards we've installed the AD-role and finished dcpromo. When we’ve reinstalled SharePoint 2010, we have some problems in the configuration of SharePoint. It automatically ask for a Databaseserver but we don't have one in the company of our project.

My question is if there is any possibility to use SharePoint with AD and without a Databaseserver. If it is possible it would be nice to tell me how.

share|improve this question

migrated from Feb 15 '11 at 14:43

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

I would normally agree with Mark's post, but the one place where it is unsupported to use the "Standalone Server" install is when you are installing to a Domain Controller. As Tim found out, the SharePoint Installer will not even give you the option if you are targeting a DC.

Tim- You'll need to install a SQL Server... just download and install the free SQL Server 2008 R2 Express (64-bit edition) from here:

I would also recommend picking up a copy of "Real World SharePoint 2010: Indispensable Experiences from 22 MVPs" from your library/Amazon/local bookstore. The very first chapter (by Shane Young) walks through how to create a single server (including AD) demo/test setup that covers all the weird things you need to do to make it work (particularly valuable for the exact problem you cover as well as the pain that is the User Profile Service)

share|improve this answer

If you don't have a database server, then you need to choose the SharePoint installation option for 'Standalone Server'. This will be more than acceptable to complete your project, and will install a SQLserver express edition on the SharePoint server you are using. Good luck!

share|improve this answer
First and foremost, I agree with Mark's answer. In this very specific case, I would recommend the "Standalone Server" install. In almost every other case, please avoid using the standalone server install, EVEN IF you plan on having your entire SharePoint server on one server. In fact, I believe a small class project to be the only acceptable situation to choose "Standalone Server." – pk. Feb 15 '11 at 18:31
Well when we worked without AD we could choose this option in the SharePoint setup. But when we install the AD-role and install SharePoint afterwards it's like we cannot choose between Standalone or Server Farm. I'll retry it tomorrow and keep you posted. – Tim Decuypere Feb 15 '11 at 21:23

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.