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 ?