Q: Using SSRS with Azure SQL databases I have a requirement to set up SSRS for reporting with one of our web applications.
Just now I have SSRS installed locally and pointing to the local version of the database for development purposes which is fine and works.
The live and test SQL databases are on Azure and I would like to be able to connect to them from the Report Designer locally to create the reports.
Does anyone have advice on how this should be done? For example, should I create a SQL database on Azure and use the SSRS configuration manager to set this as the reporting database, then from within the report designed connect to the live or test database when creating the reports?
thanks in advance
