I created an External List on Sharepoint that gets data from SQL server. On My account I can see the list data and everything works ok. I want to grant access to a group of users (Basically the whole team) I added the whole team to the sharepoint site and everyone can access it ok. However when they go to the list with External conetent I get:
Access denied by Business Data Connectivity.
What I did to try to fix:
I updated the BCS External content type permissions to include the group (Sharepoint Admin > BCS). Currently I gave them all the permissions (Edit, Execute, Selectable in Clients, Edit Permissions). I also set MetaData Store permissions to also include this group. There I also gave them all permissions like above. I have made these changes over 24 hours ago and none of the users can access the list. They all get the same error.
What am I missing? Any help would be greatly appreciated.