I am very new to SQL Server 2008r2 Reporting Services Configuration Manager in fact I have only completed the process once a few months ago before my company decided to do an upgrade and switch from SQL Server 2005 to SQL Server 2008. I configured Reporting Services Configuration Manager to use the (at the time) current database ie... 220.127.116.11. Our new database is now 18.104.22.168 and as a result none of the reports I created will run. How do I change the database from 22.214.171.124 to 126.96.36.199. I have tried several different ways and nothing has worked yet. Thanks for your help in advance.
In SSRS 2008 and above the Reporting Services Configuration Manager should automaticaly upgrade a database, if you map an older database to be used with newer version of SSRS instance. It should ask you for confirmation. Details on MSDN: [Upgrade a Report Server Database] I suggest followig steps: 1. Start Reporting Services Configuration Manager 2. Connect to appropriate SSRS Instance 3. In the Database Pane of the RSCM choose Change Database. 4. Select your Reporting Database. 5. RSCM should ask you for confirmation to upgrade existing database if it is an older version. You need sysadmin rights to be able to do this. :