Solved

moving sql reporting services to different server

Posted on 2006-06-23
4
2,713 Views
Last Modified: 2008-03-02
Hi all,
I have a SQL Reporting Services server(the Reporting db's are on a different server). Basically these are to be decomissioned and I'm trying to find out how to migrate the web and db's for the reporting service.
Will there be naming issues with moving to a different server and what about security problems??
Any help on doing this is greatly appreciated

0
Comment
Question by:lawrmc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 500 total points
ID: 16982635
Try this tool:

Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62

This article from MS is also worth a read:
http://support.microsoft.com/default.aspx?scid=kb;en-us;842425

Note: Backing up and re-installing the encryption keys is VERY important in this process

0
 

Author Comment

by:lawrmc
ID: 17010614
Ok, tried the MS KB article and followed the process. Now I get the following error on the new machine.
 
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.51'. The expected version is 'C.0.6.43'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
 
 I used the install files for reporting services from the source server(the guy who put all this together is no longer with the company) as I assumed that would be the instll directory he used.

Any thoughts, or how to tell/obtain correct versions?
 
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17011019
Looks like your dB is a newer version than your RS install.  C.0.6.51 is the SP1 version, so try installing SP1 on the RS side.

SQL Server 2000 Reporting Services Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en

To get the versions of the Report Server:
http://SERVERNAME/ReportServer

8.00.743.00 1st Release
8.00.878.00 SP1
8.00.1038.00 SP2
8.00.1042.00 Hotfix for SQL Server 2000 Reporting Services SP2 (KB901383)
0
 

Author Comment

by:lawrmc
ID: 17017961
sorted!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question