While running FEP reports, specially Antimalware Protection Summary Report, I was getting this error - Sub Report could not be opened.
If you open the report directly, you get this error - Query execution failed for dataset 'dsAMProtectionBreakdown'. (rsErrorExecutingCommand) Error 7202, Procedure -, Line 1, Message Could not find server 'FEPDW_ODU_FEPDW_ODU_OLAPProvider_FEP' in sys.servers.
Solution:
Open SQL Management Studio and try to do a test connection for the linked server - FEPDW_ODU_FEPDW_ODU_OLAPProvider_FEP and for the other one also.
The Test Connection should succeed. Check why it is not succeeding. I had my SQL Analysis Services stopped. Maybe delete the linked server and create it with correct database name.
If you open the report directly, you get this error - Query execution failed for dataset 'dsAMProtectionBreakdown'. (rsErrorExecutingCommand) Error 7202, Procedure -, Line 1, Message Could not find server 'FEPDW_ODU_FEPDW_ODU_OLAPProvider_FEP' in sys.servers.
Solution:
Open SQL Management Studio and try to do a test connection for the linked server - FEPDW_ODU_FEPDW_ODU_OLAPProvider_FEP and for the other one also.
The Test Connection should succeed. Check why it is not succeeding. I had my SQL Analysis Services stopped. Maybe delete the linked server and create it with correct database name.
