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?


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? – user1166085 Oct 15 '15 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 '15 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 – user1166085 Oct 15 '15 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 '15 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() – user1166085 Oct 15 '15 at 10:08

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.