Dynamics AX 2012 How to install/setup Multiple instances of AX 2012 R3 SSRS Reporting instances running SQL 2014

Dear All,

Greetings!

Recently, for one of my client, I had to setup multiple SSRS 2014 reporting instances 

To start with, I would suggest you to refer this document from Microsoft

http://technet.microsoft.com/en-us/library/hh389760.aspx 

To summarize, the steps I followed

1.     Install New SSRS Instance http://technet.microsoft.com/en-us/library/hh389770.aspx (We would need to do this setup by running the SQL installer)

2.     Configure New Reporting Service instance http://technet.microsoft.com/en-us/library/hh389764.aspx ( Use SSRS Config Manager Tool)

3.     This is the key piece where I struggled a bit i.e. to install a 2^nd SSRS Reporting Extension on the SSRS box http://technet.microsoft.com/en-us/library/dn527682.aspx

Syntax:

Install-AXReportInstanceExtensions –ReportServerInstanceName [SSRSInstanceName] -Credential [DomainName\UserName]

4.     Replace [SSRSInstanceName] with your SSRS instance and use the same credentials which is used by your SSRS Reporting Service

5.     Restart the new SSRS Service

6.     Create a new config http://technet.microsoft.com/en-us/library/hh389774.aspx

7.     Connect AX to new Reporting Instance http://technet.microsoft.com/en-us/library/hh389773.aspx

8.     Deploy Reports for the new Reporting Service Instance [AX 2012] http://technet.microsoft.com/en-us/library/hh389771.aspx

9.     Inorder to deploy the reports to a specific AOS instance, please refer this blog http://daxknowledgepot.wordpress.com/2012/02/14/how-to-publish-ax-reports-for-a-specific-aos-instance/

10.  Publish-AXReport –ReportName * -id AXSSRS –servicesAOSname AXServer –servicesAOSWSDLPort 8102

11.  Replace AXServer and the port number with your existing AOS Instance

12.  Revert to the original config http://technet.microsoft.com/en-us/library/hh389767.aspx

13.  Finally, couple more steps from my end I had to do is Refresh the config i.e. Go to Dynamics AX Config Utility > Refresh WCF > Configure Services. (Repeat the steps both for Local and Business connector config) Once this is done, Export the updated config and use it for your client connection