Forum Discussion

nipanesanjay's avatar
nipanesanjay
Copper Contributor
Oct 20, 2020

Hosting SSRS on Azure VM

Hi, 

I am upgrading ASP.NET 4.7 based Web Forms applications to PaaS option. These applications are having SSRS Reports.

 

For quick upgrade, we have planned to host SSRS on Azure VM so that we can have the Reporting part working as-is with minimal disruption. Only SSRS will be on Azure VM whereas we will be having Azure SQL as application database.

 

I am looking for step-by-step guide to procure Azure VM with SSRS hosted on it.

 

Please advise if any references are available.

 

Thanks

Sanjay

  • Command0r's avatar
    Command0r
    Iron Contributor
    Oct 20, 2020

    nipanesanjay there are a few caveats with accessing SSRS URL hosted within Azure VM. Please follow this instruction to configure your VM before the SSRS installation. There are images available for SQL Server 2019 on Windows Server 2019, and the fastest approach (IMO) is to get one of those images (SQL 2019 Developer), deploy a VM, finish the VM configuration after the image deployment (according to the instruction provided above), and install additional features for the SQL Server you're interested in (i.e., SSRS).

    • nipanesanjay's avatar
      nipanesanjay
      Copper Contributor
      Oct 20, 2020
      Thanks for quick feedback.
      I will go through the reference link you have provided.

      I want to install SSRS only on the Azure VM since it will be connecting to Azure SQL Database.
      • Command0r's avatar
        Command0r
        Iron Contributor
        Oct 20, 2020
        Sounds good. Please let me know how it goes. DM me if necessary, I'd be happy to help 🙂

Resources