Following
error made me worried when I was not able to run (existing or customized) SSRS
reports from AX. Reports were working fine few days back and there wasn’t a
single change done neither at report server nor with AOS service accounts.
error made me worried when I was not able to run (existing or customized) SSRS
reports from AX. Reports were working fine few days back and there wasn’t a
single change done neither at report server nor with AOS service accounts.
After digging into
issue, came across the issue was services and services groups in AOT. My AOS
was connected with TFS and when I got latest from TFS it affects SRSFramework
and SSASFramework services and there was some sort of reference lost in service
groups.
issue, came across the issue was services and services groups in AOT. My AOS
was connected with TFS and when I got latest from TFS it affects SRSFramework
and SSASFramework services and there was some sort of reference lost in service
groups.
Resolution:
Generate FULL CIL
Confirm the Business
proxy account and AOS service account is same
proxy account and AOS service account is same
Register SRSFrameworkService and
SSASFrwameworkService services from AOT
Deploy
BIServices and UserSessionServices groups from AOT
BIServices and UserSessionServices groups from AOT
Restart SQL reporting
services
services
