Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Sunday, November 20, 2011

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:

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!

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , ,


Blogger Munib Ahmed said...

I am almost done with the automating the tedious process of changing the config files "Modify Reporting Services configuration files".
I have scripted these in powershell and hope to publish an update later this week.

6:04 PM  
Blogger Munib Ahmed said...

Updated post with full working scripts

1:55 AM  

Post a Comment

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved