Archive for October, 2016

Cannot impersonate user for data source (rsErrorImpersonatingUser) error

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source ‘SMSDB’

Usually this error is caused by user account that was used to install the Reporting Role password has been changed or it’s being disabled.

Solution:

  • Launch Reporting Services Configuration Manager
  • Click on Report Manager URL
  • Click Report URL
  • Drill into SMS_DB1 Reports

You should see a Database Source

db1

Click on the Database source & you will see the properties of your DB Source.

Go ahead and change/update the credentials. You should be able to do your reporting subscription now.