Modify Reporting Services configuration files [AX 2012]

Updated: May 28, 2014

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Complete the following procedures to modify the configuration files that are used by the new instance of Microsoft SQL Server Reporting Services.

TipTip

We recommend that you make a backup of each configuration file before you modify it.

Complete the following procedure to modify the Web.config file that is used by Report Manager.

  1. Open the Web.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\ReportManager.

    • 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\ReportManager.

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

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

  2. Search for httpRuntime.

  3. Add maxRequestLength="100000" to the line of code so that the line looks like this:

    <httpRuntime maxRequestLength="100000" executionTimeout="90000" />
    

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

  1. Open the RsReportServer.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 <AuthenticationTypes> element.

  3. In the <AuthenticationTypes> element, remove the following line of code if it is present:

    <RSWindowsNegotiate>
    
  4. Find the <Service> element.

  5. In the <Service> element, add the following line of code:

    <IsRdceEnabled>True</IsRdceEnabled>
    
    
  6. Find the <Data> element.

  7. In the <Data> element, add the following lines 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.

    <Extension Name="AXQUERY" Type="Microsoft.Dynamics.Framework.Reports.AxQueryConnection,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    <Extension Name="AXDATAMETHOD" Type="Microsoft.Dynamics.Framework.Reports.AxDataMethodConnection,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    <Extension Name="AXREPORTDATAPROVIDER" Type="Microsoft.Dynamics.Framework.Reports.AxReportProviderConnection,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    <Extension Name="AXADOMD" Type="Microsoft.Dynamics.Framework.Reports.AxAdomdConnection,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    <Extension Name="AXENUMDATAPROVIDER" Type="Microsoft.Dynamics.Framework.Reports.EnumProviderConnection,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    
    
  8. Find the <Extensions> element.

  9. In the <Extensions> element, add the following lines 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.

    <ReportDefinitionCustomization>
    <Extension Name="AXRDCE" Type="Microsoft.Dynamics.Framework.Reports.AxRdce.CustomizationExtension,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    </ReportDefinitionCustomization>
    
    

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.

    <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:

              <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:

    <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>
    
    

Complete the following procedure to modify the Web.config file that is used by the report server instance.

  1. Open the Web.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 <httpModules> element.

  3. In the <httpModules> 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.

    <add name="AxReportsHttpModule" type="Microsoft.Dynamics.Framework.Reports.AxReportsHttpModule,Microsoft.Dynamics.Framework.ReportsExtensions, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    
  4. Search for httpRuntime.

  5. Add maxRequestLength="100000" to the line of code so that the line looks like this:

    <httpRuntime maxRequestLength="100000" executionTimeout="90000" />
    
  6. Find the <system.web> element.

  7. In the <system.web> element, add the following line of code if it does not already exist:

    <hostingEnvironment shadowCopyBinAssemblies="true" />
    

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: