The target prinipal name is incorrect - SSRS with AX

The target prinipal name is incorrect - SSRS with AX

MCP · Azure DevOpsYour delivery board, readable by an agentMCP · DataverseOne consent, and the data layer opensMCP · Dynamics 365 F&OConnecting F&O to an agent Microsoft hasn’t documented
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


Previous article← Assigning security roles to new AX user was never that easy !!!
Discussion

Ask a question or leave feedback

This is a review interaction. The WordPress version will store, thread and moderate comments.

Thanks — submitted for moderation in this review.
Search the whole site · Ctrl/⌘ + K