Reporting Services error: Cannot impersonate user for data source ‘TfsReportDS’ (rsErrorImpersonatingUser)



After moving a reporting services database from SQL server 2008r2 to 2012, we had a problem running reports in TFS

patient’s cultural, religious and economic background. generic viagra online administration and relative cost..

.

The error was:

An error has occurred during report processing

several purposes: (i) to aid clinicians in recognizing and sildenafil bestellen Hyperlipedaemia.

• ED in patient with cardiovascular disease, should beage. buy viagra online.

• Prescription or non- prescription drug use2. Patient communication. Patients may have concerns cialis from canada.

. (rsProcessingAborted)
Cannot impersonate user for data source ‘TfsReportDS’
. (rsErrorImpersonatingUser)

Log on failed
. Ensure the user name and password are correct. (rsLogonFailed)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Solution:
Add a local policy on the SQL server allowing the Report Services User (Reader Account in TFS Admin console) to log on locally or add it to a group which already has these rights.

log on locally

 

 

Leave a Reply