User is trying to create external content types using SQL Server, using sharepoint designer. I as an SharePoint Administrator i can login without any issue but this user who is dbo of remote sql server and is a site owner of the sharepoint site cant add connection is prompted with this error.

enter image description here

Have anyone experienced such issue in past, please share your experiences.

Thank You

  • are you an administrator of the BDC Service Application? – Mike Jun 4 '15 at 17:44
  • I am part of SharePoint farm Admin group, so i believe i have admin privilieges over the BDC application too. – allegro octopus Jun 4 '15 at 18:18
  • go to Manage Service Applications -> Business Data Catalog Service , put a check mark next to your ECT and click Set Object Permissions, and give your users like "Execute" & "Selectable in Client" – Waqas Sarwar MVP Jun 4 '15 at 19:20
  • I just found out for user to have ability to add connection user needs to have Edit permission in Metadata Store Permissions. But Edit is so highly privileged permissions, it displays all the BDC connection made by other users and gived users ability to modify them. Is there a better way to manage the users permissions, Still allow user to add connection not not have ability to edit others? – allegro octopus Jun 5 '15 at 15:40

The user in question needs to be granted access to the BDC application. In Central Administration access BDC service, select the BDC application and then grant the user the expected permissions.

  • But i cant even add the BDC application because we get that error message. – allegro octopus Jun 5 '15 at 14:05
  • You get the error in SharePoint Designer. You need to set permission in Central Administration. – Jesus Shelby Jun 5 '15 at 17:42
  • I just found out for user to have ability to add connection user needs to have Edit permission in Metadata Store Permissions. But Edit is so highly privileged permissions, it displays all the BDC connection made by other users and gived users ability to modify them. Is there a better way to manage the users permissions, Still allow user to add connection not not have ability to edit others? – allegro octopus Jun 5 '15 at 18:51

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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