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