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... 188.8.131.52. Our new database is now 184.108.40.206 and as a result none of the reports I created will run. How do I change the database from 220.127.116.11 to 18.104.22.168. 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