Need to migrate on prem SSRS to Azure Managed Instance

  • Can it possible to migrate the on prem SSRS to Azure Managed Instance ? I can see Hosting catalog databases for all supported versions of SSRS in Azure SQL Managed Instance. But don't think so, work with Managed Instance for SSRS some thing like on prem SSRS.

    As the reporting services won't be installed / running at Managed Instance. Will it be allowed to run and get reports with the services running at MI ?

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • As far as I know: you can host the two Reporting Services databases on SQL MI; but as you say, this doesn't get you the Reporting Services themselves!

    SSRS needs to be installed, separately and manually, on a VM; you can either host a local MSSQL Instance, or use SQL MI.

    Or start again in the PowerBI/ADF/Synapse world!

  • My searches led me to the same conclusion as Andy sql's:  you cannot run RS on Azure MI.

    https://techcommunity.microsoft.com/t5/azure-sql-blog/hosting-ssrs-databases-in-azure-sql-managed-instance/ba-p/1700197

    Rich

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply