This is for connecting SharePoint Foundation 2010 from BizTalk 2010, after deploying the adapter web service on the SharePoint server, adjust the TPM registry setting in the BizTalk server, my BizTalk server keep complaining although I confirmed many times the BizTalk host instance account is one of the group members.

‘The Windows SharePoint Services adapter runtime does not have permissions to invoke the adapter Web service. In order to fix this issue, you have to add the Contoso\administrator Windows account to the “SharePoint Enabled Hosts” Windows group on the Windows SharePoint Services machine’

So I am frustrated, then I turned on the adapter tracing, by monitoring on the GUID ‘BA7DAD66-5FC8-4a24-A27E-D9F68FD67C3A’. Immediately I am getting error ‘Error System.IO.FileNotFoundException: The Web application at … cannot be found’. After quite some google, I followed the advice in http://social.msdn.microsoft.com/Forums/en-US/isv/thread/5133f61e-7ae8-4a0f-867b-3f65dd58d7f2 to give biztalk account and app pool account more permission on SharePoint databases and site collection administrator privilege. It turns out it still refused to work with the same error.

The moment before I am to kill myself, I got the note to try both SharePoint application pool and BizTalk host instance in 64 bit since it is a 64 bit SharePoint deployment. So after try this out, everything works magically.