Installing SharePoint 2013 on a Single Server without a Domain Controller and using SQL Server Express


As most of you may already be aware of, there is an option for a Stand-alone installation of SharePoint 2013 which uses a SQL Server Express instance as DB. As a developer wanting to try a few things out, I tried this installation first, however I was a little disappointed because of the multiple issues I ran into in this mode of installation, it was multiple uninstall - reinstall cycles with no luck! So I wanted to give the regular Complete installation a shot, but on a single virtual machine with a single core and 4GB of RAM running Windowa Server 2008 R2, it did not sound easy! But it turned out otherwise, fairly simple with a few workarounds though!

This blog describes the steps I took to install SharePoint 2013 in the Complete installation mode.

The installation of SharePoint 2013 in the Complete mode is fairly simple with a few clicks and some patience. It took about 15-20 mins for this to complete. Next is the SharePoint Products Configurations Wizard.  On the screen shown below, the wizard doesn't allow to proceed without selecting the right version of SQL Server and specifying a domain account.

I could have setup an Active Directory on the same box, but it is not recommended to install SharePoint on a Domain Controller. The other option was to setup a second virtual machine as AD-Controller and third as SQL Server. But then, I would have to manage three servers! So I closed the wizard window.

Please note that following steps are good only for a development setup.

Next I installed  SQL Server SQL Server 2008 R2 Expression Edition on the default instance and not the named instance.

 

Note that SharePoint 2013 only supports SQL Server 2008 R2 (versions > 10.50.1600.1). You may use this link to install  SQL Server 2008 R2 Express SP2.

Once the SQL Server Express installation was complete, the trick is to use the powershell command: New-SPConfigurationDatabase to create the Config DB. You can specify the local account here! I could use the Powershell to create the SharePoint_ConfigDB successfully.

 

Once this was done, I went back to the SharePoint Products Configurations Wizard, and this time I had the default option of Connect to an Existing Farm checked. A few more clicks and I was ready to explore the new SharePoint 2013. 

 


Comments (24)

  1. Tony says:

    very useful! Thanx a lot 🙂

  2. Hessam says:

    This is one of the best/simplest solutions. From a grateful developer.

  3. Billy says:

    I agree with Hessam, brilliant article.

    Good thing I found it before installing SP 2013 for development.

  4. madhava_v says:

    Excellent post.. you same me  a lot of time, when I try to install it for development.

  5. Anu Melkote says:

    Excellent. Simple. To the Point. Great Job!

  6. Lee says:

    Exactly what I was looking for. Many thanks.

  7. Alex says:

    This is a very helpful information. I can start running my dev env right away. Many thanks.

  8. ShaileshH says:

    Thanks for the above steps, the information was helpful. However, i could not create a New Web Application because the button was disabled.

  9. TrellistNick says:

    ShaileshH – I was able to create a new web application by logging in as a different farm administrator (not the account that was used to create the SPConfigurationDatabase).  

  10. 00xx84 says:

    In this way, it's OK.

    But we cannot create Search Service Application in Central Administration (in SharePoint 2013). Because it requires sID (domain ID).

    Does anyone have ideas ?

  11. Rusty says:

    How do I configure sharepoint 2013 on a local server (without domain) to Deploy Sharepoint Hosted App ?

  12. Madan says:

    Many thanks. I was struggling with it for past few days…. Finally, I go the successful installation windows on Windows Server 2012/ SQL 2012 SP1/ SharePoint Server 2013.

    You saved my days. Thanks again.

    Cheers

  13. Chrysostomos says:

    IT GOD (if any) BLESS YOU!

  14. aowworld says:

    I'm do my work as Programmer on one VM (Windows server 2008 R2) with Domain Controller and installed Complete farm Sharepoint server 2010 and SQL server 2008 R2. every things work perfect.

    So, Can I do the same with Sharepoint 2013 ? and user User Profile service as well. or I really need 3 VMs to do my job.

    thanks to all how helping me if that work. so that I can convince the Architect guy in my department.

  15. Alireza says:

    Thanks a lot man. You saved my day 🙂

  16. Tim says:

    Very good article!  Thank you so much for this, it really saved the day!

  17. Pankaj C Patel says:

    Thank you so much for your valuable tips

  18. Ryan says:

    Brother, do we need many more people like you.  a true life saver!!!

  19. Dennis Vroegop says:

    You saved me a lot of work! Great! Finally I am able to test out some dev stuff on my Azure instance….

  20. Cameron says:

    Perhaps this cmdlet was removed from the SharePoint 2013 management shell? It's no longer present… 🙁

  21. Sihle says:

    What a great work you put in this!! Thank you for helping me out.

  22. mutanic says:

    Sir, I just install Sharepoint Foundation 2013 into my desktop Windows 8.1 Single Language, SQL Express 2008 R2, Officce 2013 Professional Plus, do I still need to setup an AD & DNS part as well?

  23. Philip Wrangles says:

    Once i have followed these steps and complete set up, when my page loads i get the error "this site has not been shared with you". Any Advice?

  24. hamza says:

    thanks 🙂

Skip to main content