Connect Microsoft Dynamics AX to the new Reporting Services instance [AX 2012]

Updated: February 24, 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 procedure to connect an instance of Microsoft Dynamics AX Application Object Server (AOS) to the new instance of Microsoft SQL Server Reporting Services. This topic assumes that the new instance of Reporting Services meets the version requirements that are listed in Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX).

  1. Open Microsoft Dynamics AX.

  2. Click System administration > Setup > Business intelligence > Reporting Services > Report servers.

  3. In the Configuration ID field, enter a name that identifies the Reporting Services instance and the AOS instance that you are connecting.

  4. In the Description field, enter a brief description to help you identify the Reporting Services instance and the AOS instance that you are connecting.

  5. Select the Default configuration check box.

  6. On the Reporting Server information tab, complete the actions that are listed in the following table.

    Field

    Action you should take

    Server name

    Enter the name of the server that is running Reporting Services.

    Server instance name

    Enter the name of the new Reporting Services instance.

    Report Manager URL

    • If Reporting Services is running in native mode, enter the URL of the Report Manager website. The URL is typically http://[SSRSServerName]/Reports_[SSRSInstanceName].

    • If Reporting Services is running in SharePoint integrated mode, leave this field empty.

      NoteNote

      SharePoint integrated mode is supported if you are using Microsoft Dynamics AX 2012 R2 or later.

    Web service URL

    Enter the URL of the Reporting Services web service. The URL is typically http://[SSRSServerName]/ReportServer_[SSRSInstanceName].

    SharePoint integrated mode

    Select this check box if Reporting Services is running in SharePoint integrated mode.

    NoteNote

    This control is available only if Microsoft Dynamics AX 2012 R2 or AX 2012 R3 is installed.

    Microsoft Dynamics AX report folder

    • If Reporting Services is running in native mode, enter a name for a report folder. The report folder will be created for you on the Report Manager website.

    • If Reporting Services is running in SharePoint integrated mode, enter the URL of a document library. The document library will be created for you on the SharePoint site that is integrated with Reporting Services. For example, suppose you want to create a document library that is named Reports on a SharePoint site that is named Contoso. In this case, you would enter the following URL:

      http://[SharePointServerName]/sites/Contoso/Reports

  7. On the Application Object Server information tab, select the name of the AOS instance.

  8. Click Create report folder to create the report folder or document library that is specified in the Microsoft Dynamics AX report folder field.

  9. Click Validate settings to verify that the information that you entered in this form is correct, and to verify that the report folder or document library has been created.


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

Community Additions

ADD
Show: