index > Team Foundation Server - General > Reporting Services woes.

Reporting Services woes.


Hi,

I installed Team Foundation Server and I can do queries but I can't create a report.

Where do I look for the account causing the following error message:

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot impersonate user for data source 'TfsOlapReportDS'. (rsErrorImpersonatingUser)
      • Logon failed. (rsLogonFailed)
        • Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)



Sr. DBA
Marcel Pighin
Can you verify that the Data Sources for the instances are correctly configured with the proper credentials. You can find the data sources at the root - they are called TfsReportDs and TfsOlapReportDs. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=769557&SiteID=1 for more details.
Ameya Bhatawdekar

Hi,

I will check on this. I also found a thread that said it could be the fact that I am using Windows 2003 which somehow defaults to an Internet Explorer instance in lockdown mode that prevents Reporting Services from getting the correct permissions to publish reports. The person accessed Reporting Systems from a Windows XP instance of IE and it worked just fine. I will work with you to get this resolved since it appears to be affecting other people. I am working at Microsoft right now and you can logon to my machine to nail down the problem and publish the results.

Thanks!

Marcel




Sr. DBA
Marcel Pighin

Hi,

Thank you for your help. This issue has been resolved.

My error was:

  • Logon failed. (rsLogonFailed)
  • Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
  • Your suggestion was:

    Can you verify that the Data Sources for the instances are correctly configured with the proper credentials. You can find the data sources at the root - they are called TfsReportDs and TfsOlapReportDs

    Marcel Pighin
    reply 4

    You can use google to search for other answers

     

    More Articles

    Out-of-the-box reports description
    Displaying custom build steps in the IDE build progress page.
    list of fixes or improvements for VSTS from Beta 2 release to Jul...
    Folder names greyed out in SCC explorer
    Ability to add "State" to the columns on Links within a...
    Team Explorer - Disconnect error
    Bug in tf merges?
    TFS Beta 3 Installation - Sharepoint not being installed/extended...
    BigBuild and password protected keys
    Problems with Team Build
    Welcome to Bokebb   New Update   Joins the collection  
     

    New Articles

    Error upon project creation - VSTS Relea…
    Workitems and Permissions
    Error encountered when adding a solution…
    Compilation 1.1 and 2.0 framework compat…
    Enabling Keyword Expansion
    Work Item "Assigned To" field …
    Recommend moving to team system now?
    How do I add visual studio 2005 solution…
    "The operation could not be complet…
    After you migrate a SourceSafe DB into T…
    When querying on Work Item Type the list…
    query conflicts is not updated
    Using Team Explorer outside VS 2005 Team…
    How to make a copy of a work item
    Duplicate copies of Work Item Queries ap…

    Hot Articles

    Source Control doesn't do an automatic g…
    Where is tbuild?
    How to display the last checked in date …
    TFS Version
    Creating conditions for check-in
    TF30162: Task "WITs" from Grou…
    Versions no longer needed?
    Team Foundation Report Site Permissions
    Code coverage / testing errors in Team B…
    Issue for printing out work item
    layout designer for Workitem forms
    Team Project Creation Failed with Soap E…
    Changeset Comparison
    Major Application vs Single small Applic…
    Doing a "Get" in Team Foundati…

    Recommend Articles

    How to add task in Team Project Portal a…
    Customer Support Representatives using TFS
    Roles and Users
    WorkspaceMapping.xml problem in RC
    RUP process support
    Get Latest and Check-out Behavior
    using MSSCCI provider for Visual studio …
    Team Explorer Beta 3 issues.
    Cannot connect to Sharepoint with IE, bu…
    Team foundation Server Working?
    Convert from ClearCase to VSTS?
    Error creating first team project
    Denied. Moving TFS to a new server does…
    Version Control doesn't recognize that t…
    Installing an updated Process Template