BizTalk tracking not working on Azure VM

Bastien Brailly-Vignal
Published by Bastien
Category : Azure
25/04/2018

When creating a BizTalk Server VM (from « BizTalk Server 2016 Developer » template for instance) on Azure,

 

create virtual machine Azure

 

BizTalk tracking simply does not work.

 

biztalk administrator tracking not working

 

To fix the issue, open SQL Server Server Management Studio and execute the following query :

 

sql fix query biztalk adminsitrator on Azure

 

Where « BIZTALK2016 » is the BizTalk Server host name previously created.

 

see hostname biztalk tracking azure

 

This command creates a linked server which will allow distributed queries to run against this server.

More information : https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-2017.