Dear All,
Greetings!
Recently, for one of my client, I had to setup multiple SSRS 2014 reporting instances
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
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
6 comments:
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.
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
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
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
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
Have you solved the CIL problem?
I encountered the same error , please share the solution
Post a Comment