I have a SQL Server Database on Azure Cloud and I want to get a report server up and runnning using SSRS that would accesses the data on that database.
Does anyone have any experience with this scenario, or could provide me some guidance on how to go about this.
I'm reading about how SSRS would run on a Azure VM and that the SQL Server and it's respective Database(s) would be installed on that Azure VM. That's not my situation as I have existing SQL Database that exists outside of any VM I spin up.
Thanks,
解决方案
You will need to host SSRS either on an Azure VM or on premise.
In this link deployment topologies for SSRS on Azure VM are discussed.
One strategy is to deploy SSRS to a VM and use Azure SQL Database as the data source.
Once you deploy the VM containing SSRS, you can then connect SSRS to an Azure SQL DB. This artcle discusses connecting Azure SQL Database to SSRS.
Hope this helps!