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 ?

I checked the same mentioned in this link.. but still getting an error Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator. correlation ID also gives me the same The error returned was 'Access is denied.'
–
Brijesh SahhNov 30 '12 at 9:34