question

Anthony avatar image
Anthony asked

Reporting Services Configuration Manager

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... 15.4.10.35. Our new database is now 15.4.10.45 and as a result none of the reports I created will run. How do I change the database from 15.4.10.35 to 15.4.10.45. I have tried several different ways and nothing has worked yet. Thanks for your help in advance.
sqlconfiguration
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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][1] 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. [1]: http://technet.microsoft.com/en-us/library/ms403392.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.