Total Pageviews

Search This Blog

Sunday, November 2, 2014

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

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 2nd 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


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

6 comments:

Josephat Kutieto said...

This is good info.

Just wondering how i would sort my setup of three aos instances.
I realized that you can only point the default report config to one AOS.
But with this, I can point an aos to a different instance...problem is that i have to deploy a report the number of times of the AOSs i have.

Anonymous said...

I am facing the same problem, error occurred during the Compilation to .Net CIL Generation, I did the same what ever you mention,
I went to the location of XPPIL directory and removed all the assembly from there, after that i synchronize the database and the full compilation and next the CIL generation, but no improvement.
I want to dictate my scenario over here.
My Database is 2012 standard and located on this (10.6.123.50)
and AX2012 R3 is on different IP (10.6.123.51).
Installation done successfully as well as Application Compile without any error.
the next step when compile with CIL Generation, error occurred "The CIL generator found errors and could not save the new assembly”.
what should be possible error in this environment.
For your clarification,
User is Member of Domain Admin and Admin of local system.
Thanking you

Mohammad Shahnawaz said...

I am facing the same problem, error occurred during the Compilation to .Net CIL Generation, I did the same what ever you mention,
I went to the location of XPPIL directory and removed all the assembly from there, after that i synchronize the database and the full compilation and next the CIL generation, but no improvement.
I want to dictate my scenario over here.
My Database is 2012 standard and located on this (10.6.123.50)
and AX2012 R3 is on different IP (10.6.123.51).
Installation done successfully as well as Application Compile without any error.
the next step when compile with CIL Generation, error occurred "The CIL generator found errors and could not save the new assembly”.
what should be possible error in this environment.
For your clarification,
User is Member of Domain Admin and Admin of local system.
Thanking you

Dilip said...

Hi, you will need to see your AX Full compilation log if you can find any errors and fix them first and then re-run your CIL Compile again

Dilip said...

Hi Josephat, I would suggest you can write your own powershell script to deploy a single report to multiple aos instances, you can store the instances in some variables and then use the Publish-Report command

Tchikou Abdellah said...

Have you solved the CIL problem?
I encountered the same error , please share the solution