I have a web application that has user credentials stored in SQL Server database(Form Based Authentication). I need to synchronize the user profile service application with the SQL Server database.

Please help me in doing this.


You need to use BCS(BCS can only be used for property augmentation). You have to do follow things

  • creating external content types from data in Microsoft SQL Server tables
  • creating synchronization connections
  • mapping user profile properties
  • Run Full Synchronization.

Please follow this video from MSFT, to complete task. http://www.microsoft.com/resources/technet/en-us/office/media/video/video.html?cid=stc&from=mscomSTC&videoid=ede7d855-035c-47a9-9492-1c2a23614a4a

also check this:


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.