Integrate BizTalk Server with Microsoft Azure SQL Database

With the rapid evolution of the services on the cloud, it is important to integrate an on-premises process with processes running in Microsoft Azure.

One of the major requirements may be to implement integration flows between systems running on-premises and Microsoft SQL Azure Database.

To do this with BizTalk Server, it is important to remember the following requirements:

 

·          Windows authentication is not supported, use SQL Server instead.

·          SSL is not required but is strongly recommended.

·          Distributed Transactions are not supported.

 

So, when you run the wizard for creating the schema is essential to specify SQL authentication.

 

clip_image001[6]

 

Then the specify Server and Database name.

 

clip_image002[6]

 

At this time, is not necessary to activate the encryption and disable the transaction, but remember to do that in the port settings from the administration console.

 

clip_image003[6]

 

If you forget to disable the support for the transactions, you will find the following error message in the application log:

 

 

The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)

 

 

 

clip_image004[4]

 

If you try to use Windows authentication, you will find the following error message in the application log:

 

 

Windows logins are not supported in this version of SQL Server

 

 

clip_image005[4]

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s