This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
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 @Sarvesh Pandey 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.
Yes, but we have created in separate subscriptions.
You won't have any issues as you can connect to the SSRS databases on the Azure SQL Managed Instance using SQL authentication. You just need the VNET of SQL Server VM to connect to the VNET on the Azure SQL Managed instance and both could belong to different subscriptions. To connect both you can use Azure VNET peering and you can use VNet-to-VNet VPN gateway also.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 49%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi,
What about the SSRS product key?