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.
More articles
Explore our blog

What can we do for you?

We'd love to hear about your project. Our team will get back to you within two working days.

Thank you for inquiry, we’ve passed it to our sales department, our representative will reach you back in his earliest convenience.
Oops! Something went wrong while submitting the form.