Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.