Hello,

I am tring to deploy external content type to Sharepoint 2010 foundation using Visual studio 2010 and I followed this:

http://blogs.msdn.com/b/vssharepointtoolsblog/archive/2010/04/02/deploy-a-bdc-model-project-to-sharepoint-foundation-2010-using-visual-studio-2010.aspx

after completing procedure I have tried do deploy solution but I always get this exception:

 Error 1 Error occurred in deployment step 'Add Solution': Access denied by Business Data Connectivity.
    Error was encountered at or just before Line: '0' and Position: '0'.
  0 0 BdcModelProjectTest

I have tried to grant myself permissions in Sharepoint central administration ( http://blogs.msdn.com/b/ericwhite/archive/2010/06/11/access-denied-by-business-data-connectivity.aspx ) but when I click ok I get this exception

No windows identity for damain\username. 0a193cf4-3811-4aa8-a657-0de3b8be3793
07/04/2011 16:46:46.31  w3wp.exe (0x0828)                        0x1414 Business Connectivity Services Business Data                  g0k9 High     Access Denied for User '0#.w|damain\username, which may be an impersonation by damain\username

 

I am really hopeless, can anyone help?

Hi,

It seems that an account are you using to deploy solution doesn't have sufficient permission in the BDC Metadata Store. In order to assign permission you should open Central Administration->Application Management->Manage Service Application->Business Data Connectivity Service->Click Set Metada Store Permission on the ribbon->Set Permission you need and tick the checkbox "Propagate permission to all..."

Hello,

thanks for answer, but when I try grant myself permissions I get this error

 

No windows identity for damain\username. 0a193cf4-3811-4aa8-a657-0de3b8be3793
07/04/2011 16:46:46.31 w3wp.exe (0x0828) 0x1414 Business Connectivity Services Business Data g0k9 High Access Denied for User '0#.w|damain\username, which may be an impersonation by damain\username

What Authentication Mode you are using to connect to your external system? Are you trying to add permissions for "All Authenticated Users" or for certain account?

I use Windows auth, but log keeps saying Claims. I have no idea why is that. Stragne thing is that I actually fixed it at one server just by turning Business data service off and on. ( I was able to deploy external content type sucessfully). The second server I manage continues to have problem.

Who is Business Data Connectivity Service Administrator (you may find it by clicking "Administrators" on the ribbon when you select Business Data Connectivity Service)? What BDC Database authentication is used (you may find it by clicking "Properties" on the ribbon when you select Business Data Connectivity Service)?

You mean to find BDC service in central administration? Because I dont see options you mentioned there. Only Import, Set permissions, Delete and one dropdown

Yes, I mean Business Data Connectivity Service.

I have added my self to administrators and checked authentication method ( windows auth ). Didnt help.

Is your account a farm administrator or not?

Of course it is. I wouldnt even try it if it wasnt (:

Hi I was facing the same scenario and tried out all that was mentioned in the above posts, but I didn't get any success. Then I did the following:

I understood that I didn't had Edit or Update BDC permission on the BDC service. To get that we need to add the user in my case myself through the "Set Metatdata Store Permissions" ribbon link. I was earlier unable to add myself to the "Set Metatdata Store Permissions" and I was able to do it only after adding myself to the Computer's (server's) Admin Groups from the Computer Management console.  Hope this helps some!

• Proposed as answer by B.Kesava Wednesday, June 04, 2014 11:08 AM

why can not you use

http://msdn.microsoft.com/en-us/library/ff798309.aspx for BCS deployment this is very easy

Adding the user account to computer admin group helped me to do "set metadata store permissions"

Hello,

I know this is an old post. But I would like to share my solution to a similar issue I had.

It was necessary to disable the UAC (User Account Control Settings) of my deployment account to be able to execute the deployment with Visual Studio. The solutions explained by the other colleagues in this thread are referring to permission issues you have once you are using the model _after_ the deployment.

Hope this helps,
patrick