A while ago I have moved the SSRS services to another database and with that I created a new ReportServer database and the TempDB that goes with it. For a while I had these four databases on the same SQL Server:
Ok, so I removed the first two because they weren't used anymore. That resulted in my subscriptions not working anymore, and it turned out that the subscriptions were still stored in the oldServerTempDB!
In the Reporting Services Configuration Manager I can only select the database of the ReportServer, but not the TempDB. So how do I control which TempDB is used? Or how can I move/modify my subscriptions so that it points to the correct database?
View Complete Post