I'm trying to setup a BCS connection from a SQL view -> user profile properties.

I've created the external content type and got the right view. I also set the "set object permission", checked all the checkboxes.

The problem is when I'm trying to create the BCS in user profile synchronization connection it says "External Content Types are not available. Contact your system administrator."

Any idea why?

enter image description here

  • How did you managed to integrate your on premise data to SharePoint, i've been jumping from site to site but haven't found any practical example and this scenario is practically the same i am trying to resolve. Do you have any resources you can share as reference? Thanks in advance! Oct 24, 2019 at 21:18

1 Answer 1


Wrong user in "set object permission", just check ther persmission and it would work!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.