Prologika Forums

Hi Teo,

Here is my setup: I have Reporting Service and SQL Server 2000 in one box (Box A), and IIS and Analysis Service in another box (Box B), which has couple of cubes based on the database in Box A, using SQL Authentication and Allow save password. Create  AS2000 data source at Reporting Project, then create a report, I can preview the report fine in VS.2003. But I got the following error after deploying the report to the reportserver and browse the report:

• Cannot create a connection to data source 'Cube'. (rsErrorOpeningConnection) Get Online Help
  • Database 'Cube' does not exist.

Do I miss anything?

Thanks

Don

The report runs fines locally b/c the call from SSRS to SSAS goes under your identity. In the distributed scenario the call fails because NTLM doesn't support cross-machine delegation. To make the long story short:

1. If you don't need to pass the interactive user identity to SSAS, in the SSRS data source use a domain account. This is also called trusted subsystem.

2. If you need to pass the end user identity to SSAS, you can enable Kerberos or prompt the user for credentials by enabling the "Credentials supplied by the user running the report" option in the data source.

This is explained in more details in section 16.4.

Thanks for the reply. Teo. But I still could not get to work, maybe I am missing something here. Here is what I did:

On SSRS Share Data Source, under Data Link Property, I put SSAS data source name, then I tried "Use Windows NT Integrated Security" (Which should not work, like you said NTLM not supporting cross server); Then I tried "Use Specific User Name and Password", I put my domain user name and password in there. And check "Allow save password". Test connection is working. Then I delete old data source and report, re-deploy the report and data source. I still get the error "cannot create connection" and "data source not exist" error.

Then I went to Report Manager, open the data source, I put my domain name and password in

"Credentials stored securely in the report server" section, check "Use as windows credentials when connecting to data source".

My connecton string is like this:Auto Synch Period=10000;Data Source=olapserver;Initial Catalog=cubedatabase;Provider=MSOLAP.2;Client Cache Size=25.

This time I got:

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
  • Cannot create a connection to data source 'RxCubeWIK'. (rsErrorOpeningConnection) Get Online Help
    • No error information available: E_FAIL(0x80004005).

I also check my OLAP server (SSAS), make sure my domain user name at OLAP admin and I create database role at the cube and add Everyone in the role.

After all that, I still could not get to work. It drives me nuts. Help!

This doesn't necessarily means that the authentication fails. Do you have the SSAS client 8.0 components (ptslite.exe) installed on the Report Server box? If the OLEDB 9.0 provider fails, it will try to do COM delegation to the 8.0 provider if it is installed

What I will do is:

1. Log in as your domain account to the Report Server machine.

2. Use the MDX sample application (or another client) to see if I can establish a connection to your SSAS 2000 database.