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