Unanswered 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 PM
     
     
    Is the address to run it from the server /reports" rel="nofollow">http://<ssrsserver>/reports or another?
  • Friday, February 17, 2012 6:49 PM
    Moderator
     
     

    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 PM
    Moderator
     
     

    There is a blog post with the same error message:

    Reporting Services Password Change problem

    Maybe this is helpful.


    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 PM
     
     
    The 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