none
Reporting Errors in Dashboard Remaining Requirements

    Question

  • When I open the Dashboard of newly created Team Projects, I get the following error only in the "Remaining Work" area.  Earlier projects do not have the problem.  If I click on the "Reporting" link in the left pane, I do not get the error.  Any Ideas?

    Reporting Services Error

    • An error has occurred during report processing. (rsProcessingAborted) Get Online Help
      • Cannot impersonate user for data source 'TfsReportDS'. (rsErrorImpersonatingUser) Get Online Help
        • Log on failed. Ensure the user name and password are correct. (rsLogonFailed) Get Online Help
          • For more information about this error navigate to the report server on the local server machine, or enable remote errors

      SQL Server Reporting Services

    mp
    Tuesday, January 24, 2012 7:47 PM

Answers

  • Hi Marvin,

    Welcome to the forums

    1) Does the user attempting to read the reports have view access on the report itself / is a member of Team Foundation Content Manager's group on the report server site?

    2) Try the following:

    • Navigate to http://<tfsserver>/reports
    • Click on TFS2010OlapReportDS
    • Confirm that the credentials listed under "Connect Using" are the correct credentials of your TFS service account and have the option "Use windows credentials when connecting to the data source" checked and have permission to your TFS warehouse.
    • Test your connection and confirm it successfully establishes.

    Let us know how you get on.

    Regards,

    Patrick S


    Patrick Squire - http://www.msblog.org
    • Marked as answer by MarvinPerkins Wednesday, January 25, 2012 9:25 PM
    Wednesday, January 25, 2012 5:21 AM

All replies

  • Hi Marvin,

    Welcome to the forums

    1) Does the user attempting to read the reports have view access on the report itself / is a member of Team Foundation Content Manager's group on the report server site?

    2) Try the following:

    • Navigate to http://<tfsserver>/reports
    • Click on TFS2010OlapReportDS
    • Confirm that the credentials listed under "Connect Using" are the correct credentials of your TFS service account and have the option "Use windows credentials when connecting to the data source" checked and have permission to your TFS warehouse.
    • Test your connection and confirm it successfully establishes.

    Let us know how you get on.

    Regards,

    Patrick S


    Patrick Squire - http://www.msblog.org
    • Marked as answer by MarvinPerkins Wednesday, January 25, 2012 9:25 PM
    Wednesday, January 25, 2012 5:21 AM
  • Patrick,

    Thanks for the quick response.  I did as you said and found that the User that was currently configured failed to make a connection.  I changed to another ID that could connect successfully, but I still received the same error.

    I then guessed at the Service Account for TFS (based on a UserID I found running one of the TFS Processes) and set that as the UserId in the Reporting Configuration.  That did the trick!  Every report I try, either from the Dashboard or from VS.2010, runs like a charm!

    Thanks so much for your assistance and solution!

    Marvin


    mp

    Wednesday, January 25, 2012 2:24 PM
  • Hi Marvin,

    I just saw your response - I'm glad your reports are up and running - thanks for making my answer.

    Regards,

    Patrick S


    Patrick Squire - http://www.msblog.org
    Wednesday, January 25, 2012 11:55 PM