Hi everybody,
Last night I've applied some pending Windows Updates on our CRM 2015 environment. Although the patching process went perfectly fine, it seems that Reporting has been affected due to the Manual Failover switch from AG Node 1 - Primary to AG Node 2- Secondary(switched back AG Node 1 to Primary after boot).
While accessing Reports in CRM the following error is thrown:
Web service request SetDataSourceCredentials to Report Server http://ReportServer failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)
Reporting Log says that it cannot connect to the Datasource due to the following error:
System.Data.SqlClient.SqlException: Connecting to a mirrored SQL Server instance using the MultiSubnetFailover connection option is not supported. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Connecting to a mirrored SQL Server instance using the MultiSubnetFailover connection option is not supported.
I am pretty sure that this has been caused after the Manual Failover.
Can anyone with knowledge about this help me or point me to the necessary configuration to have this fixed?
Thanks in advance and Kind Regards,
BM
