upgrading the SQL server 2005 RTM reporting service to SP2.

Posted on 2012-08-17
Last Modified: 2012-09-03
Dear all,

I heard that if the SQL Server 2005 RTM edition has reporting service installed, we need to do something first, right?

What it is ? backup the encryption key ?

just want to make the whole process smooth enought for the reporting service.
Question by:marrowyung
    LVL 28

    Accepted Solution

    I don't believe you have to do anything before you run this service pack - I've never had any issues running an SP on SQL Server. If you wanted to back up the key just to be safe, here are the instructions:
    LVL 42

    Assisted Solution

    where are your ssrs dbs: on the same box with ssrs (sql server is there)?
    it is alwayse good to have ssrs db backup.. you can baqckup with rs.exe reports and ds as well:
     just in case.
    but as the idea: you should be fine with sp2 : it is normaly a very  simple process (if you did not have any problems with original inmstall and all files are there )

    BTW: why not sp4?
    How to obtain the latest service pack for SQL Server 2005

    also just FYI
    LVL 1

    Author Comment


    "BTW: why not sp4?"

    Yeah, just because we are running SP2 on some of the machien and the third party application are running just fine. So we are making a lot of sense that we have to make sure that the rest of the SQL server that are still running RTM to all upgrade to SP2 as it is already proof that SP2 is working fine for our apps,

    We can later on, after the SP2 still give no problem after all upgrade to SP2, then SP4. But do you think there are problem on upgrade from SP2 to SP4 ?

    LVL 1

    Author Comment

    ok, so just backup the key and backuop the reportserver + reporttempdb, that's it ?

    for a cluster upgrade, just run the hotfix.exe on the active node on SQL 2005 (in SQL 2008, we can do rolling upgrade on passive node!!) and the change will be replicate to all nodes?
    LVL 1

    Author Comment

    I saw this, it seems that I need to:

    1)      Backing Up the Reporting Services Web Sites
    2)      Backing Up the Configuration Files
    3)      Backing Up Data Files

    but it seem that I can't find the configuration file on the reporting server box, anyway to do the above item easlier?

    LVL 1

    Author Closing Comment

    I tried update the reporting service and it is smooth enough

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now