Cannot create a connection to data source 'DynamicsAXOLAP'

[Jensen]

Hello
We have Ax 2009 installed and it is working fine. We have three server one
for AOS , 2nd for SQL Reporting 2008 and Ax EP server and third one is for
SQL DB and SQL Analysis Services Server. Kerberos is configured and Ep is
working fine but I am getting the following error on some Reports in
Enterprise Portal site on the Terminal Server. It is working fine on the
Reporting Server/EP server.

Cannot create a connection to data source 'DynamicsAXOLAP'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors"

OLAP is installed. Any ideas? firewall is off on all servers. Analysis Cubes
has no error in processing.

Thanks

jensen

[Lance [MSFT]]

DynamicsAXOLAP' is a datasource on the reporting server.
Find in the ssrs website and verify the connection string inside points at
the correct ssas server and database
open http://ServerName:port/Reports
open folder Dynamics
open datasource SharedLibrary.DynamicsAXOLAP
look at the connection string and check what is set for the Data source and
the Initial catalog. Data source should be set to the machine name for your
ssas server and initial catalog should be set to the name of the cube
database. The name of the cube database is normally set to 'Dynamics AX'

[Thor]

we have same problem and i have 100% sure connection string is right. i have
access from RS server to all reports but from all other i havet to role
center reports.

thor