I got a problem when using BCS in SharePoint Foundation 2010. I'm not able to let other users see the BCS content. I tried all the possibilities I found in internet (giving permission to the users in SP central administration, changing the connection properties, ...) but I get all kind of errors:

but Which is actually the account that is used for the BDC service (I get the error Login failed for user 'ADM\PC64$', so would it be 'ADM\PC64$'?). If I try to create a user called ADM\PC64$ in the SQL but it says that the name has invalid characters. I'm using SharePoint Foundation so I don't have Secure Store Service.
–
pepersviewMar 9 '12 at 9:54