Run the Install-AXReportInstanceExtensions command [AX 2012]

Updated: May 28, 2014

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.

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.

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.

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.


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

Community Additions

ADD
Show: