After upgrading to a new 64-bit OS on our BizTalk server, I was unable to get the WCF-SQL adapter working - kept getting the "No valid adapters are installed on this machine" error message. The Admin Console had SOME of the WCF adapters visible, just not WCF-SQL. I found out that this was due to the fact that I had simply installed the 64-bit version of the Adapter Pack - both Visual Studio and the BizTalk Admin Console run as 32-bit processes, so you'll need to install that version as well.
So, to get ALL of your adapters working on a 64-bit machine, install the Adapter Pack products in the following order:
- 64-bit WCF LOB Adapter SDK SP2
- 64-bit BizTalk Adapter Pack.
- 32-bit BizTalk Adapter Pack.