question

SarveshPandey-7139 avatar image
0 Votes"
SarveshPandey-7139 asked AmiraliShahsavani-4095 answered

Deploy SSRS report on Azure SQL Managed Instance

Do we need to create Azure SQL VM on same subscription where Azure SQL MI is provisioned? Deploy SSRS report on Azure SQL MI.

azure-sql-databasesql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered OuryBa-MSFT converted comment to answer

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.



· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, but does Azure SQL MI has to be in same region as of Azure SQL VM on which SSRS is provisioned.

0 Votes 0 ·

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.

0 Votes 0 ·

Yes, but we have created in separate subscriptions.

0 Votes 0 ·
Show more comments
AmiraliShahsavani-4095 avatar image
0 Votes"
AmiraliShahsavani-4095 answered

Hi,

What about the SSRS product key?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.