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.
Then the specify Server and Database name.
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.
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)
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