Solved

moving sql reporting services to different server

Posted on 2006-06-23
4
2,710 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 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