Hosting SSRS Reports on Azure Virtual Machine

Owned by Madhuri Dange (Unlicensed)
Last updated: Apr 28, 2023
3 min read


This topic contains sub-topics that describe how to enable SSRS reports on Azure instance. It includes step- by-step instructions on how to deploy SSRS reports and configure the reporting server.

Deploying SSRS Reports

To enable SSRS reports on Azure instance, make the configuration changes as described in below steps. For Smart Client (Desktop) application set the values in Aptify Shell.Exe.config file and for Aptify Web application set the value in Web.config file.

Step 1: Go to the Azure portal and navigate to Aptify service API. Change the value of attribute Aptify.Framework.LoginServices.AptifyLogin.IsRequestFromAzureInstance to true in the Web.config files. By default, the value is false.

For Aptify Smart (Desktop) Client, do the same changes in Aptify Shell.Exe.Config file.

<add key="Aptify.Framework.LoginServices.AptifyLogin.IsRequestFromAzureInstance" value="true" />

Step 2: On Azure Virtual Machine, copy AptifyServiceAPI folder which is hosted as an app service on Azure portal for Aptify web and rename it to AptifyReports. Just change folder name, other content within the folder remains the same.

Below IIS screenshot shows physical path to configure AptifyReports folder name and Application Pool.

 

Step 3: Go to Kudu of Aptify Azure App Service and navigate to the below path ‘C:\inetpub\wwwroot\Aptify\script\Aptify\configuration\Aptify\Aptify.Framework.Configuration.External.js'. Change the value of attribute Aptify.framework.configuration.ssrsReportsUrl to the SSRS URL. This URL redirects SSRS reports request to IIS site configured in Step2.

For example, below screenshot shows the path of app service and js file.

Configuring SSRS Reporting Server

 To configure Reporting servers on Azure VM, follow the steps given below:

  1. Go to the reporting server and connect to it.

  2. Select Web Serivce URL from the left panel, on the Web Service URL page, add keyword SSRSReportServer to Virtual Directory.

  3. Select Database from the left panel, on the Report Server Database page, provide SQL server name and connect to it.

  4. Select Web Portal URL from the left panel, on the Web Portal URL page, note the URLs. The URLs get generated automatically.

In case any NT AUTORITY\IUSR related error occurs while opening SSRS report in Desktop or Web, assign all the roles to NT AUTORITY\IUSR in the reporting server.

See also Configuring SSRS reports on Azure Virtual Machine