SSRS with SSAS – Message with no host or could not find host in AX 2012

Continue reading

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: Get-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.
Subscribe to our newsletter

Get Dynamics 365 news and insights

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.