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.


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 :) – Robert Lindgren Mar 22 '14 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 '14 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 '14 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 '14 at 8:14
  • Yep, I think that is the big take away: it works, but is not supported :) – Robert Lindgren Mar 22 '14 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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