Sunday, February 8, 2015

The target prinipal name is incorrect - SSRS with AX

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.




























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.

Resolution:

Generate FULL CIL
Confirm the Business proxy account and AOS service account is same
Register SRSFrameworkService and SSASFrwameworkService services from AOT



Deploy BIServices and UserSessionServices groups from AOT


Restart SQL reporting services