Hosting SSRS Reports on Azure Virtual Machine

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

Deploying SSRS Reports
Configuring SSRS 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: In Kudu, where the Aptify App Service is hosted, navigate to the below path ‘C:\inetpub\wwwroot\Aptify\script\Aptify\configuration\Aptify\Aptify.Framework.Configuration.External.js' and 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.

How to configure the same for Crystal report????

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:

Go to the reporting server and connect to it.
Select Web Serivce URL from the left panel, on the Web Service URL page, add keyword SSRSReportServer to Virtual Directory.
Select Database from the left panel, on the Report Server Database page, provide SQL server name and connect to it.
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.