Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error when trying to d...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
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

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,056 on at
    RE: Error when trying to deploy a report: permission set doesn't exist

    Hi All,

    And this is full and actual link to resolve the issue.

    docs.microsoft.com/.../modify-reporting-services-configuration-files

    Best Regards,

    Shabir

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,056 on at
    RE: Error when trying to deploy a report: permission set doesn't exist

    Hi all, 

    Please follow the below way to resolve this issue

    Modify the report server RsSrvPolicy.config file

    Complete the following procedure to modify the RsSrvPolicy.config file.

    1. Open the RsSrvPolicy.config file.

      • If you are using SQL Server 2008, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS10.[SSRSInstanceName]\Reporting Services\ReportServer.

      • If you are using SQL Server 2008 R2, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS10_50.[SSRSInstanceName]\Reporting Services\ReportServer.

      • If you are using SQL Server 2012, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS11.[SSRSInstanceName]\Reporting Services\ReportServer.

      • If you are using SQL Server 2014, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS12.[SSRSInstanceName]\Reporting Services\ReportServer.

    2. Find the <SecurityClasses> element.

    3. In the <SecurityClasses> element, add the following line of code. If you are using Microsoft Dynamics AX 2012, use 6.0.0.0 as the version number. If you are using Microsoft Dynamics AX 2012 R2, use 6.2.0.0 as the version number. If you are using Microsoft Dynamics AX 2012 R3, use 6.3.0.0.

      Copy 
      <SecurityClass Name="AxSessionPermission" Description="Microsoft.Dynamics.Framework.Reports.AxSessionPermission, Microsoft.Dynamics.Framework.Reports, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
]

    4. Find the <NamedPermissionSets> element.

    5. In the <NamedPermissionSets> element, add the following lines of code:

      Copy 
                <PermissionSet class="NamedPermissionSet" version="1" Name="AxSessionPermissionSet">
              <IPermission class="AxSessionPermission" version="1" Unrestricted="true" />
              <IPermission class="SecurityPermission" version="1" Flags="Assertion" />
            </PermissionSet>

    6. Find the <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Execution" Description="This code group grants MyComputer code Execution permission. "> element.

    7. Directly after the <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Execution" Description="This code group grants MyComputer code Execution permission. "> element, you’ll find the <IMembershipCondition> element. Add the following lines of code after the <IMembershipCondition> element:

      Copy 
      <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="AX_Reports_Strong_Name" Description="This code group grants Dynamics AX Reports code full trust. ">
             <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100B5FC90E7027F67871E773A8FDE8938C81DD402BA65B9201D60593E96C492651E889CC13F1415EBB53FAC1131AE0BD333C5EE6021672D9718EA31A8AEBD0DA0072F25D87DBA6FC90FFD598ED4DA35E44C398C454307E8E33B8426143DAEC9F596836F97C8F74750E5975C64E2189F45DEF46B2A2B1247ADC3652BF5C308055DA9" />
          </CodeGroup>
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

    Hi Ahmad,

    Have you resolved the issue. If yes, Can you please let us know the solution.

    Thanks,

    Vijay

  • Suggested answer
    Vinod Bhandari Profile Picture
    Vinod Bhandari 220 on at
    RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

    Hi Ahmad,

    After adding the user to local administrator group on SQL server resolves the issue, We were able to deploy the reports successfully.

    Regards,

    Vinod Bhandari

  • AhmadHammoud Profile Picture
    AhmadHammoud 250 on at
    RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

    We have checked and the user has permissions.  We checked the rssrvpolicy.config file on the original SSRS server and permission sets exist in its contents, however the  rssrvpolicy.config on the SQLDB01 and SQLDB02 permission sets are missing from the file contents.

    What are the permission sets responsible for, and how are they deployed, are they deployed when installing reporting extensions of AX on the server ? Can we configure AX so that it does notice reporting services active on SQLDB01 and SQLDB02 ?

    I am sorry for asking too much, but the it is a serious issue for us, that has been halting our work for some time now.

  • Faqruddin Profile Picture
    Faqruddin 1,871 on at
    RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

    Dear Ahmad - Please check SQL Server Reporting Services Site Settings under select Security option and check the your is authorized to deploy the reports..

  • AhmadHammoud Profile Picture
    AhmadHammoud 250 on at
    RE: Dynamics AX 2012 R3 - Error when trying to deploy a report

    Thanks Nuno for your reply, however as I specified before the SSRS dedicated server is separate and is not clustered with the SQLDB01 and SQLDB02 servers. Is there any way I can stop and remove AX reporting service on SQLDB01 and SQLDB02 server and keep it only on the intended SSRS server ?

  • nunomaia Profile Picture
    nunomaia 9 Super User 2024 Season 1 on at
    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.

  • AhmadHammoud Profile Picture
    AhmadHammoud 250 on at
    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.

  • nunomaia Profile Picture
    nunomaia 9 Super User 2024 Season 1 on at
    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 ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans