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 provides instructions on how to add the WCF-SQL adapter to the BizTalk Server Administration console.
Important |
|---|
| You need not perform these tasks if you want to configure a WCF-Custom port for the SQL adapter. |
-
Start the BizTalk Server Administration console.
-
In the console tree, expand the BizTalk Group, expand Platform Settings, and then click Adapters.
-
Right-click Adapters, point to New, and click Adapter.

-
In the Adapter Properties dialog box, specify a name for the adapter and from the Adapter list, select WCF-SQL.

-
Click OK.
Important