Export (0) Print
Expand All
4 out of 4 rated this helpful - Rate this topic

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

Updated: January 10, 2014

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

You can install multiple instances of Microsoft SQL Server Reporting Services on the same computer. In this kind of deployment environment, each instance of Reporting Services is connected to an independent Microsoft Dynamics AX installation. You may want to install multiple instances of Reporting Services on the same computer for the following reasons:

  • To support development and production installations of Microsoft Dynamics AX

    For example, in the following sample diagram, assume that AOS instance 1 is a development installation of Microsoft Dynamics AX, and AOS instance 2 is the production installation of Microsoft Dynamics AX.

  • To support multiple production installations of Microsoft Dynamics AX

    For example, if you are a Microsoft Dynamics AX solution provider, you may have to support multiple production installations of Microsoft Dynamics AX. For this scenario, assume that AOS instance 1 (in the sample diagram) is a production installation of Microsoft Dynamics AX for one client, Northwind Traders. Assume that AOS instance 2 is a production installation of Microsoft Dynamics AX for another client, Contoso Pharmaceuticals.

Multiple SSRS instances installed on one computer

To install multiple instances of Reporting Services on the same computer, you must use one of the following versions of Reporting Services:

  • Reporting Services 2008 in native mode

  • Reporting Services 2008 in SharePoint integrated mode

  • Reporting Services 2008 R2 in native mode

  • Reporting Services 2008 R2 in SharePoint integrated mode

  • Reporting Services 2012 in native mode

NoteNote

You cannot install multiple instances of Reporting Services 2012—that run in SharePoint integrated mode—on the same computer.

For more information about the service packs and updates that must be installed with each version of Reporting Services, see the Microsoft Dynamics AX system requirements.

To set up an environment that has multiple Reporting Services instances on the same computer, use the following procedure.

  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. Configure the next instance of Reporting Services and integrate it with Microsoft Dynamics AX. To do this, complete the following steps:

    1. Install the new Reporting Services instance

    2. Configure the new Reporting Services instance

    3. The action you should take in this step depends on whether you are using cumulative update 7 for Microsoft Dynamics AX 2012 R2.

    4. Restart the new Reporting Services instance

    5. Create a new Microsoft Dynamics AX configuration

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

    7. Deploy reports for the new Reporting Services instance

    8. Revert to the original Microsoft Dynamics AX configuration

  3. Repeat step 2 for each additional instance of Reporting Services.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.