x

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.
more ▼

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

Anthony gravatar image

Anthony
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][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
more ▼

answered Jun 08, 2012 at 05:59 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x738
x32

asked: Jun 07, 2012 at 11:17 PM

Seen: 1198 times

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