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]: /answers/storage/attachments/75675-capture.jpg
Hi @raminsa-6505,
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.
So did you reset the execution account username and password? Did you wait 10 minutes?
Hi @raminsa-6505,
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://docs.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.
after runing above query we get two Row in result
unfortunately i have know idea what to do and how go ahead to fix my issue
please let me know how to resolve in detail
Dear @Amandayou-MSFT your solution fixed my issue
Thank you a million times
Hi,
Thank you very much for the update and we're glad the problem is solved now. If you have any questions in future, we warmly welcome you to post in Q&A again.
Have a nice day!
Regards,
Amanda
5 people are following this question.
