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

Let's talk about your needs!

It will take a moment to fill out the 3-step form and we will contact you to hear your needs.

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.