How to install two instances SSRS on one server
Scenario:
I have 2 AOS AX (maybe same in one server or different servers), but only one server for reporting server (I will install and configure multiple SRS instances in this server). Thing is how can we install and configure 2 SSRS instances on same server and running for 2 AOS.
Problems:
First you need to install 2 SSRS instance in same server, and install reporting service component
for first AOS, this step is very simple. The problems come when we install second reporting service component
for second AOS.
Reporting service component uses business connector to connect to AX, and it’s saved on configuration in Registry. When we install second reporting service component
it will through message that component already installed.
How to do:
- After installed second instance into
C:\Program Files\Microsoft SQL Server\MSRS12.InstanceName\Reporting Services\ReportServer\bin
, we need to create oneDynamics.AX.ReportConfiguration.axc
file by AX configuration client with second AOS information.
- Open
MS Dyanmics AX Management Shell
, run command below:
Install-AXReportInstanceExtensions –ReportServerInstanceName [SSRSInstanceName] -Credential [DomainNameUserName]
- Go to
C:\Program Files\Microsoft SQL Server\MSRS12.SecondInstance\Reporting Services\ReportServer
fixfileconfi
with value fromExecution
toFullTrust
After this, remember restart reporting services.
From now on, you can run 2 AX reporting instance in same server.