Run the Install-AXReportInstanceExtensions command

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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

The Install-AXReportInstanceExtensions command is a Windows PowerShell command that you can use to integrate multiple instances of Microsoft SQL Server Reporting Services—that are running on one computer—with Microsoft Dynamics AX. The Install-AXReportInstanceExtensions command modifies Reporting Services configuration files. If you do not run the Install-AXReportInstanceExtensions command, you must manually modify the configuration files, as described in Modify Reporting Services configuration files.

Prerequisites

Before you can complete the procedures in this topic, you must make sure that the following prerequisites are met.

Category

Prerequisite

Required software

Windows PowerShell 2.0 must be installed on the computer that you are using.

Cumulative update 7 for Microsoft Dynamics AX 2012 R2 or Microsoft Dynamics AX 2012 R3 must be installed in the environment.

Required permissions

You must be a member of the Administrators group on the server that runs Reporting Services.

NoteNote

If your Windows domain account is assigned to a group that is a member of the Administrators group, it may take some time to validate that you are a member of the Administrators group. If you experience a delay when you run the Install-AXReportInstanceExtensions command, consider adding your Windows domain account directly to the Administrators group.

If Reporting Services is running in native mode, you must be assigned to the System Administrator role on the Report Manager website.

Required tasks

  1. Configure the initial instance of Reporting Services and integrate it with Microsoft Dynamics AX. To do this, complete the procedures in Checklist: Install the Reporting Services extensions and deploy reports.

  2. Install and configure the next instance of Reporting Services. To do this, see Install the new Reporting Services instance and Configure the new Reporting Services instance.

Make backups of the Reporting Services configuration files

We recommend that you make a backup of each Reporting Services configuration file. Make a backup of each file listed in the following table.

File

Default location

Web.config

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

RsReportServer.config

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

RsSrvPolicy.config

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

Web.config

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

Run the Install-AXReportInstanceExtensions command

Complete the following procedure to run the Install-AXReportInstanceExtensions command. This command modifies Reporting Services configuration files.

  1. Open Windows PowerShell as an administrator by following these steps:

    1. Click Start > Administrative Tools.

    2. Right-click the Microsoft Dynamics AX 2012 Management Shell option.

    3. Click Run as administrator.

  2. Run the Install-AXReportInstanceExtensions command. Note the following information:

    • [SSRSInstanceName] is the name of the Reporting Services instance that you are integrating with Microsoft Dynamics AX.

    • [DomainName\UserName] is the domain and user name of the Business Connector proxy account.

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

    For more information about the Install-AXReportInstanceExtensions command, see Install-AXReportInstanceExtensions.

Next steps

After you run the Install-AXReportInstanceExtensions command, you must complete these steps to fully integrate the Reporting Services instance with Microsoft Dynamics AX.

  1. Restart the new Reporting Services instance

  2. Create a new Microsoft Dynamics AX configuration

  3. Connect Microsoft Dynamics AX to the new Reporting Services instance

  4. Deploy reports for the new Reporting Services instance

  5. Revert to the original Microsoft Dynamics AX configuration

See also

Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX)