Recently, our team installed a new BizTalk Server 2016 with "Always On High Availability" SQL Servers. We configured the BizTalkMsgBoxDb to run on Availability Groups A (Secondary) and other databases are on Availability Groups B (Primary).
The below error occurred when we executed a task in BizTalk Health Monitor (BHM):
DataAccess::RunExecutionAsync: Login failed for
user 'NT AUTHORITY\ANONYMOUS LOGON'.
This is because the BHM query could not access database on Availability Groups A (Secondary).
There are two options resolve this issue:
1 - Make both Availability Groups (A&B) to run on Availability Groups Primary
2 - Enable "Readable Secondary"
This should allow BHM to query as expected.