Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

moving sql reporting services to different server

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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 …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

618 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