We are paying annually for user licenses to access a 3rd party application. The application has a database instance on our local in-house SQL server. The database instance is pretty much locked down, but they are allowing us SELECT privileges, so we were able to generate a lot of reports using SSRS.
We are now moving away from hosting the application and database in-house, and moving towards their (our 3rd party vendor) cloud solution. The application and database will be hosted by them. I'm 99.9% sure, we will have no control over the SQL server, and therefore will not be able to install SSRS.
Is it possible to preserve our SSRS server, and simply change the connection strings on all existing reports to point to the new SQL server in the cloud?
Any other ideas on how to preserve existing reports?