AX 2012 - Install multiple instances of SSRS
One area that might rise up during implementation needs, specifically for small and mid-sized deployments of Microsoft Dynamics AX 2012, is the ability to install multiple instances of SQL Server Reporting Services (SSRS) on a single server role. The goal, with this need, is to enable the two instance of SSRS, to reside on the same server role, yet, point to different instances of AX 2012.
This is critical for enabling multiple instances of AX 2012 to function, while not increasing the need for another actual server role, virtual or not. To enable this, Microsoft has refined the steps in order to achieve this, which I've done now several times actually. The home page on TechNet for achieving this task can be found here.: TechNet: Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX) [AX 2012]
The steps for achieving this second instance, after doing the initial SSRS deployment, can be found as follows:
- Install the new Reporting Services instance
- Configure the new Reporting Services instance
- Modify Reporting Services configuration files
- Restart the new Reporting Services instance
- Create a new Microsoft Dynamics AX configuration
- Connect Microsoft Dynamics AX to the new Reporting Services instance
- Deploy reports to the new Reporting Services instance
- Revert to the original Microsoft Dynamics AX configuration
With this in hand, and making sure you pay special attention to the order of these steps, and follow each step correctly, you should, with relative ease, be able to install multiple instances of SSRS on the same server role, pointing to different instances of AX 2012.
I will point out, that there is a chance you could run into a possible deployment security related issues, that I wrote about in the past: AX 2012 - SSRS Security deployment issue.
Hopefully this will help someone out, who is wanting to take advantage of having multiple SSRS instances on the same windows server role, pointing to different instance of Microsoft Dynamics AX 2012.
That's all for now, but check back soon as I continue my dive into Workflows, Performance series post, design patterns, Dynamics Ecosystem coverage, as much, much more!
Till next time!