question

raminsa-6505 avatar image
0 Votes"
raminsa-6505 asked ·

sccm report fail

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

mem-cm-co-management
capture.jpg (21.7 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered ·

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:
77029-312.png

And change the password for the service that uses this account:
77053-3122.png

Beside, change the password of account in database and service account:
76929-3121.png
77054-3125.png

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.



312.png (14.2 KiB)
3122.png (398.0 KiB)
3121.png (189.8 KiB)
3125.png (133.6 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
1 Vote"
GarthJones-MVP answered ·

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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered ·

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.


· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
raminsa-6505 avatar image
0 Votes"
raminsa-6505 answered ·

Dear @Amandayou-MSFT your solution fixed my issue

Thank you a million times

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·