Domain Users cannot access reports
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
June 20th, 2011 4:46am
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
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2011 5:10am
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
June 20th, 2011 5:10am
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
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2011 5:10am
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/
June 20th, 2011 5:14am