Install Reporting Extensions on a named instance of SQL Server:
Installing Reporting Extensions on a default instance of SQL Server is a straightforward step but installing Reporting Extensions on a named instance is a little bit of a challenge. If you install Reporting Extensions from the GUI then you need to go and make some modifications on the registry but here I have used the Ax Management Shell and deployed the reports.
Note: I have installed three instances of Reporting Services on the same box. Based on this setup, i have installed reporting extensions on the named instance of SQL Server 2014 Reporting Services.
- The first step is to use the cmdlet AxReportInstanceExtensions and ReportServerInstance with the Install command. The generic format is
Install-AxReportInstanceExtensions – ReportServerInstance <Nameoftheinstance> -Credential <logindetails>
2. This will automatically create the Report Server configuration ID under the System Administration section. The Report Server Configuration is available under System Administration -> Setup -> Business Intelligence -> Reporting Services -> Report Servers
This will open the Reports Server Configuration ID window. The configuration ID is already created because the installation task is done through the Ax Management Shell.
3. The next step is to create the DynamicsAx Folder where the reports will be deployed. Validate the settings of the DynamicsAx folder and this will check the connection string and if the connection is successfully established the following message will be displayed.
4. On successful deployment, the message Deployment completed must be displayed.