Edit

Share via

Connect to SQL Server using the adapter

  • Article

The Microsoft BizTalk Adapter for SQL Server requires adapter clients to provide a connection string, called the connection Uniform Resource Identifier (URI), to connect to the SQL Server database. Internally, the SQL adapter maps the URI to a database connection string to connect to the SQL Server database. With a connection URI, adapter clients can specify connection parameters to connect to an external system. For more information about the connection URI, see Create the SQL Server Connection URI.

In the connection URI, you can also specify the name of a failover SQL Server database on a standby computer to connect to if the primary SQL Server database is not available. The failover SQL Server database must be a mirror of the primary SQL Server database. The failover SQL Server database is specified using an optional parameter, FailoverPartner, in the connection URI. Providing a failover SQL Server database ensures high availability and data redundancy. For more information about high availability with respect to SQL Server, see Database Mirroring in SQL Server.

Make sure you comply with the security guidelines when establishing a connection with the SQL Server database. For more information about security guidelines, see Secure your SQL applications.

See Also

Overview of BizTalk Adapter for SQL Server
Create a Connection to SQL Server