cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Advanced Reporting SSRS Report fails with Cannot impersonate Log on failed user name or password incorrect

GeraldC1
Community Manager

SQL Advanced Reporting SSRS Report fails with Cannot impersonate Log on failed user name or password incorrect

I am getting this error and cannot generate a report. Is there a quick fix or where do I go to enter the credentials it needs?

 

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot impersonate user for data source 'UC'. (rsErrorImpersonatingUser)
      • Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
        • The user name or password is incorrect

 

 

 

 

 

SSRS-Report-log-on-failed-error.png

1 ACCEPTED SOLUTION

Accepted Solutions
GeraldC1
Community Manager

Re: SQL Advanced Reporting SSRS Report fails with Cannot impersonate Log on failed user name or password incorrect

Yes. There is a quick fix to try for this which is to enter in the credentials. And the correct place to find the credentials is in Home > Data Sources > UC (or whatever solution name).

SSRS-Report-log-on-failed-error-Update-Credentials-Home-Datasource.pngSSRS-Report-log-on-failed-error-Update-Credentials-Solution.pngSSRS-Report-log-on-failed-error-Update-Credentials-Solution-enter-credentials.png

 

 

<script type="text/javascript" async src="https://play.vidyard.com/embed/v4.js"></script>

 

View solution in original post

1 REPLY 1
GeraldC1
Community Manager

Re: SQL Advanced Reporting SSRS Report fails with Cannot impersonate Log on failed user name or password incorrect

Yes. There is a quick fix to try for this which is to enter in the credentials. And the correct place to find the credentials is in Home > Data Sources > UC (or whatever solution name).

SSRS-Report-log-on-failed-error-Update-Credentials-Home-Datasource.pngSSRS-Report-log-on-failed-error-Update-Credentials-Solution.pngSSRS-Report-log-on-failed-error-Update-Credentials-Solution-enter-credentials.png

 

 

<script type="text/javascript" async src="https://play.vidyard.com/embed/v4.js"></script>

 

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar
Top Liked Members