Create a connection to SQL Server

 

The Microsoft BizTalk Adapter for SQL Server is a Windows Communication Foundation (WCF) custom binding. As such, it enables communication to a SQL Server database through a WCF endpoint address. In WCF, the endpoint address identifies the network location of a service and is typically expressed as a Uniform Resource Identifier (URI). The SQL adapter expresses this location as a connection URI, which contains properties that the SQL adapter uses to establish a connection to the SQL Server database. You must specify a connection URI when you:

  • Create a channel factory or a channel listener using the WCF channel model or when you create a WCF client or service host using the WCF service model.

  • Create a physical port binding in a BizTalk Server solution.

  • Use the Add Adapter Service Reference Visual Studio Plug-in to generate a WCF client class or WCF service interface for a WCF service model solution.

  • Use the Consume Adapter Service BizTalk Project Add-in to retrieve message schemas from the SQL adapter for a BizTalk Server solution.

  • Use the ServiceModel Metadata Utility tool (svcutil.exe) to generate a WCF client class or WCF service interface for a WCF service model solution.

The topics in this section describe how to establish a connection between the Microsoft BizTalk Adapter for SQL Server and the SQL Server database by providing you with:

  • Information about the connection properties and the structure of the SQL Server connection URI.

  • Links to topics that show how to specify a connection URI by using the SQL adapter.

  • Information about connecting to SQL Server using Windows Authentication.

Develop your SQL applications

Show: