TDDS is not running on any host instance in <SQL_SERVER_NAME>.BizTalkMgmtDb [SQLSTATE 42000] (Error 50000). The step failed.
In my case, this was caused when the Tracking host instance was stopped. The tracking host instance needs to be enabled on at least one of the BizTalk servers.
- Logon to, one of, the BizTalk servers.
- Expand the Group
- Expand Applications
- Expand Platform Settings
- Select Host Instances
- Locate the Tracking instance in the list of host instances
- Right click the Tracking instance and select start.
Once complete, re-run the SQL job to that it completes successfully. The next run of the BHM report should no longer contain the issue.