Guiding businesses through their digital transformation journey
When using Microsoft Dynamics AX, you installed Management Reporter (MR) CU14 or higher you might see an error in MR with the text “Connecting to a mirrored SQL Server instance using the ApplicationIntent ReadOnly connection option is not supported.” Even worst you see MR do something like this:
Management Reporter is redirecting to a “Read only” part of the database by SQL. This is based on the Application Intent property, or lack thereof. Thankfully there is an easy resolution.