Adding the SQL Adapter to BizTalk Server Administration Console
The SQL adapter can be used in BizTalk either as a WCF-Custom port or a WCF-SQL port. If you want to use the SQL adapter through a WCF-Custom port, you do not need to add the WCF-Custom port to the BizTalk Server Administration console because the WCF-Custom port is added to the BizTalk Server Administration console by default. However, if you want to use the SQL adapter through a WCF-SQL port, you must first add the WCF-SQL adapter to the BizTalk Server Administration console.
This topic shows you how to add the WCF-SQL adapter to the BizTalk Server Administration console.
Important
You do not need to follow these steps if you want to configure a WCF-Custom port for the SQL adapter.
Add the SQL Adapter
Open the BizTalk Server Administration console.
Expand the BizTalk Group, expand Platform Settings, and then select Adapters.
Right-click Adapters, point to New, and select Adapter.
In the Adapter Properties dialog box, enter a name for the adapter, and from the Adapter list, select WCF-SQL.
Select OK.
See Also
Building blocks to develop BizTalk applications with the SQL adapter