Add SSRS to my SQL Server Managed Instance

Brian Dominguez (Admin) 0 Reputation points
2026-06-23T19:45:05.37+00:00

Hi, We created a SQL Server Managed Instance and Will like to add the report role and enable SSRS to generate report from the managed instance, How can we do that?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Deepesh Dhake 245 Reputation points
    2026-06-29T03:25:34.64+00:00

    SQL Managed Instance is the database engine only, it doesn't run the SSRS service itself, so there's no "report role" to enable on the MI side. SSRS needs its own host. The two integrate cleanly, though, and you have two paths:

    Option 1 - Run SSRS against the Managed Instance

    Stand up SSRS on a separate Windows VM (Azure VM or on-prem), then point it at the Managed Instance:

    • The SSRS catalog databases can live on the Managed Instance - natively supported since SSRS 2019. The report server engine itself runs on the VM, not on MI.
    • Connect using SQL Server authentication - MI doesn't support Windows auth, and SSRS doesn't support Entra ID (Azure AD) auth, so a stored SQL login is the only option here.
    • Make sure the VM has network line-of-sight to the MI: VNet peering or a VPN gateway between the VM's VNet and the MI's VNet, with the required ports open. This is the step people most often get stuck on.
    • Configure it through Report Server Configuration Manager - point the server name at your MI, choose SQL Server Account authentication, and select the ReportServer database.

    Your report data sources then query the Managed Instance like any other SQL Server target.

    Option 2 - Power BI Paginated Reports

    If you'd rather not maintain a VM, migrate your .rdl reports to Power BI paginated reports (Premium or Fabric capacity). As mentioned by @Bruce (SqlWork.com) Migration guidance: https://learn.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi

    Was this answer helpful?

    0 comments No comments

  2. Bruce (SqlWork.com) 84,251 Reputation points
    2026-06-23T22:11:15.59+00:00

    Azure SQL Server Managed Instances don't directly support SSRS as it's been retired (SQL Server 2022 was the last to support SSRS). You have two options:

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.