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... Our new database is now and as a result none of the reports I created will run. How do I change the database from to I have tried several different ways and nothing has worked yet.

Thanks for your help in advance.

more ▼

asked Jun 07, 2012 at 11:17 PM in Default

avatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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:

  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.

more ▼

answered Jun 08, 2012 at 05:59 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 07, 2012 at 11:17 PM

Seen: 1376 times

Last Updated: Jun 08, 2012 at 05:59 AM

Copyright 2018 Redgate Software. Privacy Policy