Connecting to a mirrored SQL Server instance not supported

Connecting to a mirrored SQL Server instance not supported

Connecting to a mirrored SQL Server instance not supported

If you have installed Management Reporter (MR) CU14 or higher you might have seen 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 have seen MR do something like this:

Blog Image 1

Issue:
Basically Management Reporter is getting redirected to a “Read only” since of the database by SQL. This is based on the Application Intent property, or lack thereof. Thankfully there is an easy resolution.

Resolution:

  1. Stop the MR services
  2. Navigate to the MR Service folder
    1. \Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services
  3. Open the MRServiceHost.settings.config
  4. Add the key below. Make sure it is set to false:
    1. <add key=”SetApplicationIntentReadOnly” value=”false” />
  5. Restart the MR services
Share on Google+Tweet about this on TwitterShare on LinkedInShare on FacebookEmail this to someone