Running Report Error
-
Wednesday, February 15, 2012 8:28 PM
When attempting to run a report, the SCSM console produces this error:
This occurs each time when attempting to run a report. SCSM is registered with the DW. Any thoughts?
All Replies
-
Thursday, February 16, 2012 6:44 AM
Hi,
Just some ideas,
Have you tried to run the reports from the Reporting Service Webiste?
If so, do you get the same.
Perhaps this is a permissions issue.
As long as you learn something new every day, the day is not wasted.
-
Friday, February 17, 2012 6:24 PMIs the address to run it from the server /reports" rel="nofollow">http://<ssrsserver>/reports or another?
-
Friday, February 17, 2012 6:49 PMModerator
http://<ssrsserver>/reports
From there you can click through the needed report.
Andreas Baumgarten | H&D International Group
- Marked As Answer by crawfish124 Friday, February 17, 2012 7:09 PM
- Unmarked As Answer by crawfish124 Friday, February 17, 2012 10:35 PM
-
Friday, February 17, 2012 10:37 PM
I went through the address to run the report from the server and received this error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'DWDataMart'. (rsErrorImpersonatingUser)
Log on failed. (rsLogonFailed)
-
Friday, February 17, 2012 11:10 PMModerator
There is a blog post with the same error message:
Reporting Services Password Change problem
Andreas Baumgarten | H&D International Group
-
Monday, February 20, 2012 5:05 PM
Wasn't the same error I had but thanks ^
-
Monday, February 20, 2012 7:20 PMThe user the report is impersonating does not have access to DW. Are you able to use that account to authenticate to other services?
Allen Anderson Systems Analyst Arizona State University - OKED Knowledge Informatics

