sccm report fail

Question

Hi dear expert we using sccm 2012 1703 after changing domain user password we unable to open any report in sccm in we get below error *we set domain user for all SQL services please give me hand in detail ![75675-capture.jpg][1] [1]: /api/attachments/75675-capture.jpg?platform=QnA

Answer 1

Hi @ramin sa ,

After my research, if we change domain user password, passwords of this account elsewhere also need to be changed, please check them.

First, kindly change the account in sccm account:

And change the password for the service that uses this account:

Beside, change the password of account in database and service account:

Finally, restart the report server configuration manager to check if we could be able to open any report in sccm.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

So did you reset the execution account username and password? Did you wait 10 minutes?

Answer 3

Hi @ramin sa ,

This issue could occur if data sources are missing entries or are incorrectly configured in SQL Server Reporting Services (SSRS).

To resolve this issue, use the following query to get the data sources:

select Path,Cast(Cast(Content as varbinary(max)) as varchar(max))
from dbo.[Catalog]
where Type = 5

Here is the detailed article we could refer to:
https://learn.microsoft.com/en-us/troubleshoot/system-center/scsm/cannot-impersonate-user-data-source

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Dear @Amandayou-MSFT your solution fixed my issue

Thank you a million times