locked
Cannot impersonate user for data source 'TfsReportDS'

    Question

  • As per TFS Configuration used separate account as Report Reader.

    Getting below error while viewing the reports.

    An error has occurred during report processing. (rsProcessingAborted)

        Cannot impersonate user for data source 'TfsReportDS'. (rsErrorImpersonatingUser)

    Logon failed. (rsLogonFailed)

    If I check on Reports sites URL,

    there are 2 data sourses available named Tfs2010ReportDS and Tfs2010OlapReportDS

    Wednesday, August 18, 2010 10:19 AM

All replies

  • Hi,

    The datasources has been renamed in 2010. The datasource named TfsReportsDS is now named Tf2010sReportsDS  and the TfsOlapReportsDS is now named Tfs2010OlapReportsDS

    Try reconnect them against the new datasource. Click on the properties tab on your report and select Data sources on the left side.

    Wednesday, August 18, 2010 1:08 PM
  • Hello,

    Thanks Jehan for your reply.

    I have already selected new datasources and even tried reconnecting them.But still the same error.Is anything is missing??

     

    Thursday, August 19, 2010 3:46 AM
  • Few more details about this issue-

    While configuring TFS RTM 2010,As report reader account I used TFSService account but it was giving warning if I go ahead with service account.That's why I have used separate account(TFSReport) as Report Reader account to generate Reports during TFS 2010 RTM configuration.

    I have added reader account on both app as well as data tier as Allow Log on permission.

    Am I missing anything??

    Thursday, August 19, 2010 3:54 AM
  • Hi j_bond,

    How did you set the Credentials for the datasources? Please uncheck Impersonate the authenticated user after a connection has been made to the data source


    Best regards,
    Ruiz
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg @ microsoft.com
    Friday, August 20, 2010 2:01 AM
  • Hi Ruiz,

    I have similar seetings as given by you.Impersonate the authenticated user after a connection has been made to the data source is already unchecked.

    The datasources are Tf2010sReportsDS & Tfs2010OlapReportsDS

    But error is mantioning TFSReports as data source......not Tf2010sReportsDS????

    An error has occurred during report processing. (rsProcessingAborted)

        Cannot impersonate user for data source 'TfsReportDS'. (rsErrorImpersonatingUser)

    Logon failed. (rsLogonFailed)

     

    Ruiz...plz check below thread as well.its urgent,,,,,,,,

    http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/06138840-f997-4fb4-b29a-960dd7bae337

     

    Friday, August 20, 2010 7:25 AM
  • Ruiz,

    Could you please check this.Its urgent??

    Thanks in advance.

    Monday, August 23, 2010 11:41 AM