When running report connected with SSAS users get message “No such host is known” or “A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <host or IP>”.
Step 1
Check if host used in OLAP data source exists and there are correct permissions to connect to the host for SSRS and BI users.
Step 2
Sometimes you will need to change host in OLAP data source. To fix it:
- Open Microsoft Dynamics AX Management Shell.
- Run command: G
et-AXReportDataSource -DataSourceName DynamicsAXOLAP| format-list
- Copy the string from “ConnectionString”, change value in property “Data Source=” to your correct
SSASServerNme\SSASNamedInstance and run the command:
Set-AXReportDataSource -ConnectionString “<ConnectionString>” -DataSourceName DynamicsAXOLAP
- Redeploy reports to SSRS.
More articles