0 out of 1 rated this helpful - Rate this topic

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.

Dd788552.Important(en-US,BTS.10).gifImportant
You need not perform these tasks if you want to configure a WCF-Custom port for the SQL adapter.

  1. Start the BizTalk Server Administration console.

  2. In the console tree, expand the BizTalk Group, expand Platform Settings, and then click Adapters.

  3. Right-click Adapters, point to New, and click Adapter.

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

    Add WCF-SQL adapter to BizTalk
  5. Click OK.

Did you find this helpful?
(1500 characters remaining)