Issue:
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).
Solution:
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.
2009-2017 Phidiax, LLC - All Rights Reserved