Do we need to create Azure SQL VM on same subscription where Azure SQL MI is provisioned? Deploy SSRS report on Azure SQL MI.
Do we need to create Azure SQL VM on same subscription where Azure SQL MI is provisioned? Deploy SSRS report on Azure SQL MI.
Hi @SarveshPandey-7139 Thanks for Posting your question. No, as long as there is connection establish between the VM hosted on SSRS and MI. Meaning, for cross-region connectivity there must be global VNet peering or VPN Gateway connection established and ports open.
Hope that helps
Regards,
Oury
SQL Managed Instance cannot run SSRS as a service, it can host SSRS catalog databases for a reporting server installed on Azure Virtual Machine, using SQL Server authentication.
Here you will find all the details.
Yes, but does Azure SQL MI has to be in same region as of Azure SQL VM on which SSRS is provisioned.
I would not even consider to have them on separate regions as it will cost you more for bandwidth usage for transferring data between regions.
On the other hand, I am not aware any restriction for not having them on different regions.
10 people are following this question.