?
Solved

moving sql reporting services to different server

Posted on 2006-06-23
4
Medium Priority
?
2,715 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 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
How to increase the row limit in Jasper Server.
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

764 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