PENDING Strange issue with datawarehouse server sccm 1810

[angel2020]

Hi
i have strange issue with datawarehouse server and sccm 1810.

i have a standalone primarie server with et remote sql server for report services.

on report services i hacve a sql service account for mssqlserver service and a dedicated account for report service.
i build a server for dataware house
i create another dedicated service acount for mssqlserver service and a dedicated srvice account for report.
in this configuration have 4 account.
so when i install datawarehouse role, there no error and the scheam was update with synch.
but when i want to load report i have this error.
An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'. (rsErrorImpersonatingUser) Log on failed. Ensure the user name and password are correct. system execption

i have this question, may i use the same account from sql server sccm report (the remote) or may i have ti check something else.
thank for your help

 

[Prajwal Desai]

may i use the same account from sql server sccm report

Give a try, I never had this issue in my lab setup. Let me know if that account works.

 

[angel2020]

Hi
all account work fine on report services server, i try to use the same account from report services server on datawarehouse server.
may be with some log i can upload if you want file you can help me?
u try to understand and ii don't