We are using SQL 2008 standard. I have build some SSRS reports based on a SSAS data cube, and deployed the reports. I can open the reports trough the url http://TESTHOST/ReportServer But domain users can open this site and open report folders, but when they click on one of the reports, they get this error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DimTrajectContractenTrajectcode'. (rsErrorExecutingCommand) Either the user, EB\lavrijsen, does not have access to the SSAS_1 database, or the database does not exist. How to solve this? Thanks in advance, regards, Hennie

Hello Hennie, In the "Datasouces" to the cube you have defined to use the actuall windows user to logon to the cube, but the others don't have permission to connect to the cube; therefore they get this error message. Change the settings of the "Datasource" to impersonate the logon, e.g. to use the service account of SSRS; then you only have to give this account permission to access the cube. See e.g. http://msdn.microsoft.com/en-us/library/ms160330.aspx Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich Blog Xing

Hello Hennie, In the "Datasouces" to the cube you have defined to use the actuall windows user to logon to the cube, but the others don't have permission to connect to the cube; therefore they get this error message. Change the settings of the "Datasource" to impersonate the logon, e.g. to use the service account of SSRS; then you only have to give this account permission to access the cube. See e.g. http://msdn.microsoft.com/en-us/library/ms160330.aspx Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich Blog Xing

Hello Hennie, In the "Datasouces" to the cube you have defined to use the actuall windows user to logon to the cube, but the others don't have permission to connect to the cube; therefore they get this error message. Change the settings of the "Datasource" to impersonate the logon, e.g. to use the service account of SSRS; then you only have to give this account permission to access the cube. See e.g. http://msdn.microsoft.com/en-us/library/ms160330.aspx Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich Blog Xing

Hi, Currenly i believe the Report Validates the datasource coonection against the user who loags in. To by-pass this . 1.http://testhost/Reports <<ReportManager URL>> 2.Go to the folder where you have your Datasource. 3.Click on Datasourc-->Manage-->Credentials Stored in ReportServer. 4.Save the Credentials used to access the Cube<<DoaminUser>> and Click Apply. Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/