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

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.
Share it
Written by
Michal Szemplinski

Microsoft Dynamics developer from July 2008. Comes from Tychy in Poland. Graduated at Silesian University of Technology as Computer Science Master.