MicrosoftHI thanks you for answering.
So what would be my alternative for th two system databases ?
The customer owns SQL2012 Standard and IT has schedule a migration to Azure without consulting with me first.
Migration is inevitable.
Now I am faced with either upgrading to SQL2019 (too expansive) or have all users buy a PowerBI Pro licence and I would migrate my reports to PowerBI but not with PowerBI Premium Service (way too expansive) but with a per User Power BI Pro licence.
But I tested a few reports and a have many hours to spend to migrate SSRS report to PowerBI Paginated Reports. Some reports do not migrate without some modifications.
So in the mean time I would like to simply migrate the existing Windows 2012R2 VM running SQL Server 2012 SSRS (not the database just SSRS. I would stop the SQL service) to Azure and reconfigure SSRS to Connect to the Azure SQL Managed Instance.
So SSRS would be in Azure in its own WIndows 2012R2 server and would connect to an Azure Sql Managed instance.
Where would the two SSRS databases be then ?
