Phidiax Tech Blog

Adventures in custom software and technology implementation.

BizTalk Server 2016: BizTalk Health Monitor Login Failed with Always On High Availability Group


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.


Privacy Policy  |  Contact  |  Careers

2009-2017 Phidiax, LLC - All Rights Reserved