Installing Reporting Services on existong server
-
I have a backup SQL Server machine that I want to move our reports to but the person that installed SQL Server did not install Reporting Services and I cannot find the original installation disc.
Does anybody know how I can install it without the disc? I have hunted far and wide on the internet but cannot find it.
regards
Ron
-
without the install disk, it's not possible; you'll have to find the disk.
from there, it's pretty easy:
backup the existing encryption key right away, before you do anything else.
you need the key as well as several database backups (ReportServer,ReportServerTempDB,Subscribers) from the original server.
if you renaming the existing server before you backup your key, your screwed and will not be able to recover the data; you'd have to start fresh and redeploy all the reports....assuming you can find the reports in a single centralized location.
then on the new server, you restore the encryption key, and either point to the existing server/database, or restore the databases on the new target server.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
If someone at the company has an MSDN subscription, you can download the SQL Server installation media.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Good thought but we do not have any. Thank you anyway.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply