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.
asked Jun 07 '12 at 11:17 PM in Default
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:
answered Jun 08 '12 at 05:59 AM