Install WCF SQL Adapter

Following steps must be done on a 64 Bit system to install the WCF SQL Adapter:

1) \\OrgFiles\BT Server\ASDK_x64\AdapterFramework64.msi –> complete
2) \\OrgFiles\BT Server\AdapterPack_x64\AdapterSetup64.msi –> custom, select only Microsoft BizTalk Adapter for Microsoft SQL Server
3) \\OrgFiles\BT Server\AdapterPack_x86\AdapterSetup.msi –> custom, select only Microsoft BizTalk Adapter for Microsoft SQL Server

Background: Administration console and the integration for Visual Studio are based on 32 Bit, so you also need the 32 bit version of the adapter to finalize the setup process.

4) Biztalk Server Administration / BizTalk Group / Platform Settings / Adapters –> context menu –> new–> Adapter

5) Insert a name, e.g. WCF-SQL
6) Select WCF Sql Adapters from the dropdown list
7) OK