Access is denied in SharePoint BDC Secure Store Service application

Question

I have one serious issue with BCS of SharePoint 2010, If you can help. I want to use external data (from SQL Server). For that I have configure Business Data Connectivity Service. and also created Secure Store Connection using my credential.

Now, it was working fine & it populate the correct data. but when i tried with different user credential it gives me no result with correlation id.

I checked that using ULVLog & it says The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.'. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).

Now, I have given all most all the permission to this user like from the Database level i have given him admin rights on that database. In Secure Store I have given him full permission. In BDC Service Object I have added him with full access. In that SharePoint site i have added him in admin Group. still don't know why it gives me same ?

Answer 1

Enabling Anonymous Access to a BCS External List

http://sharepoint.mindsharpblogs.com/pauls/Lists/Categories/Category.aspx?Name=SharePoint%20Designer%202010

Answer 2

If you want a single account to be used for BCS Connection and not give permissions to all the users then you can use RevertToSelf Authentication Mode for BCS Service Application as described in SP 2010: BCS problem with AuthenticationMode and RevertToSelf

About the permission changes not taking place, try resetting IIS or restarting Timer Service!

Answer 3

Having this issue - made the change to Administrators for the secure store as described here: http://blogs.msdn.com/b/jimmiet/archive/2012/07/04/10326828.aspx

BUT - still didn't work until I restarted the Timer Service.

Be sure to try that too.

Thanks!