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.

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: