I installed Report Portal 2.2 on a server with Windows 2003 server, and I have another server with analysis services 2000 (Both servers are in the same Domain). UDL connection works fine but report portal donīt see the catalogue. I must set something in the OLAP DB or datasources.xml file? Thanks!
Set the XMLA virtual directory to use Anonymous access only. The anonymous user should have access to your Analysis Services server. Make sure that both (IIS and SSAS) belong to the same domain.
To test the SSAS connectivity between the servers try this test:
1) Login to your web server with account you use for Anonymous user 2) Create an UDL file (Just create a blank text document and rename it to test.udl) 3) Choose Microsoft OLEDB Provider for OLAP services under the Provider tab 4) Data Source: You SSAS server name 5) Initial catalog to use should show you the list of databases the Anonymous user is allowed to see
Report Portal
XMLA Configuration - Analysis Services 2000
Posted - 05/24/2008 : 06:54:56
