We're trying to configure BDC connection to SQL 2005 on our MOSS install that uses ExCM. I'm not able to configure the BDC web parts when logged in through ExCM. When logged in through AD I can configure the web part if I use the RevertToSelf connection type.
Once configured, I can use the web part via AD, but receive the following error via ExCM:
You do not have permission to access ProjectPeople_vw in TUF_OttoInstance.
I receive this even if I grant all access to "everyone".
Is it possible to configure BDC for ExCM users?