TDDS is not running on any host instance in BizTalkMgmtDb [SQLSTATE 42000] (Error 50000). The step failed.

Error:

TDDS is not running on any host instance in <SQL_SERVER_NAME>.BizTalkMgmtDb [SQLSTATE 42000] (Error 50000).  The step failed.

Cause:

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.

Solution:
  • 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.

Leave a Reply