How do I import user profile directly from an external source (SQL database) without using active directory?

The common usual solution is to have a SharePoint privilege account that have the replicate directory changes to start the user profile synchronization service and then use the Business Connectivity Service of SharePoint to connect to a SQL.

However in my project, we are unable to get the replicate directory changes privilege to the account.

Thus, is it possible to start the User Profile Synchronization Service WITHOUT granting the 1) Replicate Directory Changes in the AD 2) Granting the domain user account "sp_farm" the local admin account so that we can synchronize the user profile using BCS from an external data source?

1 Answer 1


You can synchronize using BDC.

  • i found this article. however, it still requires me to start the user profile synchronization service before i can create a new connection. And that will require SharePoint privilege account (spfarm, spprofileservice etc) that have the replicate directory changes. to my understanding, that requires an AD right? Oct 15, 2015 at 7:57
  • I don't think. Replication Rights are AD permissions, right, but in this case you'll configure your synchronization on Business Data Catalog, that means an SQL DB. I don't see any references to AD.
    – Seb
    Oct 15, 2015 at 8:09
  • in my SharePoint 2013, when i go to Configure Profile Synchronization -> Add New Connection -> it shows me an error message "Cannot navigate to the request page because User Profile Synchronization Service is not running. Please start the User Profile Synchronization Services before creating a connection" and when i try to start the User Profile Synchronization Services it fails. one of the possible explanation for the failure is that the account doesnt have replicate directory changes Oct 15, 2015 at 8:18
  • Do you know why does it fail? best way is to track the ULS logs on the server you're starting it.
    – Seb
    Oct 15, 2015 at 8:25
  • Failure retrieving application ID for User Profile Application Proxy 'User Profile Service App': Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileApplicationNotAvailableException_Logging :: UserProfileApplicationProxy.ApplicationProperties ProfilePropertyCache does not have 3fb1994c-eedf-4394-a1c2-e74b0790dc0b at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_ApplicationProperties() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_AppID() Oct 15, 2015 at 10:08

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.