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!
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
コメントを追加