Install Reporting Extensions on a named instance of SQL Server

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.

  1. 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>

Featured image

    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

 Featured image

           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.

Featured imageFeatured image 4.  On successful deployment, the message Deployment completed must be       displayed.

Featured image

Featured image


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s