Establishing 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.