January 9, 2025 at 1:06 pm
Hi ,
one of my on-premises servers one server is having databases and one more server maintain the reporting services .
above 2 servers having connectivity between them .
we are planning migrate into Azure Managed Instance .do we need 2 managed instance single managed instance .
If Single Managed Instance how can we add the Reporting Services to Managed INSATNANCE.
January 9, 2025 at 2:53 pm
If your SSRS reports are pulling the data from databases hosted on Azure SQL Managed Instance, consider hosting report server databases on the same instance, thus minimizing the database engine footprint.
SQL Server 2019 Reporting Services come with native support for hosting report server databases in Azure SQL Managed Instance – just point your SSRS to the instance during the setup, or re-point the existing installation using SSRS Configuration Manager. You can also restore a backup of your report server database from on-premises SQL Server on Azure SQL Managed Instance.
Eddie Wuerch
MCM: SQL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply