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.

1 Answer 1


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 and acknowledge you have read our privacy policy.