Synchronize user and group profiles in SharePoint Server 2013

This article mentions that You must have a full installation of SQL Server, not the Express edition. Profile synchronization will not work if you have installed SharePoint Server 2013 by following the instructions in Install SharePoint 2013 on a single server with a built-in database.

However, we are setting up the Profile synchronization by using SharePoint AD Import.

We would like to know if the profile sync using SP AD import is supported for single server installation.

1 Answer 1


If you have your AD on the same server as SQL Server and SharePoint Server, then it's not supported by Microsoft. However, it's a common setup for a development environment and it does work well.

If you're setting up a production environment, then don't have the AD on the same server as SQL or SharePoint.

  • How about SQL Express that is mentioned in the post? My dev envs usually have an SQL Server versions :) Mar 22, 2014 at 7:29
  • My dev setup has SP2013 and SQL on 1 machine and AD on another DC machine and the user profiles were successfully imported. So it Works this way..
    – variable
    Mar 22, 2014 at 7:39
  • @RobertLindgren If you succed inställning on SQL Express I think it works, but again, it's not supporter by MS :)
    – Benny Skogberg
    Mar 22, 2014 at 8:12
  • @NachiketKamat It works, but preferably you should consider moving the SQL Server to another Windows Server for performance reasons.
    – Benny Skogberg
    Mar 22, 2014 at 8:14
  • Yep, I think that is the big take away: it works, but is not supported :) Mar 22, 2014 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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