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... 184.108.40.206. Our new database is now 220.127.116.11 and as a result none of the reports I created will run. How do I change the database from 18.104.22.168 to 22.214.171.124. I have tried several different ways and nothing has worked yet.
Thanks for your help in advance.
asked Jun 07, 2012 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, 2012 at 05:59 AM