Microsoft Dynamics AX (Archived)

Error when trying to deploy a report: permission set doesn't exist

(0) Share

Report

Posted on by AhmadHammoud

250

I can't seem able to deploy an SSRS report, I keep getting the error in the screenshot bellow

3326.Capture-1.PNG

Configuration ID: ****SSRSCONFIG
Description:
Default: True
Report server name: ****
Report server instance name: MSSQLSERVER
Report server folder name: DynamicsAX
Report server manager URL: http://****ssrs/Reports
Report server web service URL: http://****ssrs/ReportServer
Application Object Server name: 01@****

The Microsoft Dynamics AX permission set doesn't exist in the \\****SQLDB02\C$\Program Files\Microsoft SQL Server\MSRS11.AX\Reporting Services\ReportServer\rssrvpolicy.config file.

The Microsoft Dynamics AX permission set doesn't exist in the \\****SQLDB01\C$\Program Files\Microsoft SQL Server\MSRS11.AX\Reporting Services\ReportServer\rssrvpolicy.config file.

Report name: LedgerJournal
Design names: LedgerJournal.Report
Deployment status for design names: Success
Assembly names: LedgerJournalReport.BusinessLogic.dll, DrillThroughCommon.dll
Deployment status for assembly names: Error, Error

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Try to install Reporting Extensions, using the command

Install-AXReportInstanceExtensions –ReportServerInstanceName [SSRSInstanceName] -Credential [DomainName\UserName]

Also check technet.microsoft.com/.../dn527682.aspx

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Thanks for your reply Nuno, however this issue was not occurring before, all of sudden I can't deploy. Missing installations of Reporting Extension might have been the cause if I wasn't able to deploy reports from the start.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Please refer the Nuno's reply if your side installed another reporting service instance in a single server.

technet.microsoft.com/.../dn527682.aspx

Please also refer this URL for troubleshoot

technet.microsoft.com/.../gg724094.aspx

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Hariharan, thanks for your reply, but I guess the issue is a little more complicated, allow me to explain. The environment we are working with has a separate SSRS reporting server,an AOS server and two fail over cluster SQL servers. AX is configured to deploy reports to the default reporting server which is the SSRS server which was working fine before, now for some reason we cant deploy any reports as per the error above in my post. I checked both SQL servers, and on both server reporting services needs configuration. I did configure reporting services on one of the SQL servers, however the error still refers to the said server. We recently configured Management Reporter, I dont know whether this got to do aything with the issue we are facing .

Was this reply helpful? Yes No
Suggested answer

Pir_Rana 836 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Hi Ahmed,

Try this: Go to AOT > Services > SRSFrameworkService And register the service.

After that in AOT > Service Group > BIServices and deploy this group.

After that try to deploy report after sometime.

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Sadly that did not resolve the issue, I still am facing the same error.

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

One question is why is AX asking me about permission sets for SQLDB01 and SQLDB02 when as far as I know I never installed AX reporting services on both. How can I configure AX so it does not ask check from both servers reporting services.

Was this reply helpful? Yes No
nunomaia 25 Moderator on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

In System administration > Setup > Business intelligence > Reporting Services >

Report servers.

You have the the virtual server that makes the load balancing or you have a direct server ?

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

Under reporting servers there is only configuration for SSRS server. There is no configuration of the SQLDB01 and SQLDB02 servers. Virtual Server does the clustering.

Was this reply helpful? Yes No
nunomaia 25 Moderator on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

If you have a virtual server it will load balance between the existing reporting services, if want to use a single one SSRS server, you must not use a virtual server.

Was this reply helpful? Yes No