none
SharePoint user profile service application on domain controller? RRS feed

  • Question

  • Does SharePoint user profile service application work if both SharePoint and domain controller are on same machine.

    Is there any known issue with this scenario?

    We are getting following error, also user profile sync service is not getting started.

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Portal Server
    Event ID:      5553
    Task Category: User Profiles
    Level:         Error
    Keywords:      
    Description:
    failure trying to synch site 5e2fb00-4504-434f-9b07-4436a3246af0 for ContentDB 6078a8f0-eb6b-4ce9-829c-288befbdea25 WebApp 50b2f876-dd4a-4f15-ae59-90ed683d0zf2.  Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'.
    The statement has been terminated.

    Wednesday, June 7, 2017 12:57 AM

All replies

  • Hi Jason Samurai,

    It is not recommended to install SharePoint on domain controller.

    Here is a blog lists some issues when using SharePoint on Domain Controller:

    https://briankgough.wordpress.com/2009/07/16/sharepoint-on-a-domain-controller/

    The Event 5553 occurs because the SharePoint Timer Job "User Profile to SharePoint Full Synchronization" fails. The most common reason for this job to fail is inconsistent user profile data between the user profile service and the content database.

    Run the following stsadm command to list information about the databases that have not been synchronized with the user profile service since 'n' days.

    stsadm -o sync -listolddatabases n

    Then, use the following command to deletes old records corresponding to these databases. It does not delete the databases themselves.

    stsadm -o sync -deleteolddatabases n

    For more information, you can refer to the article below:

    https://support.microsoft.com/en-us/help/2771190/failure-trying-to-synch-site---event-id-5553

    Best Regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, June 8, 2017 4:47 AM
    Moderator