Sql 2005 database and Reporting services

Posted on 2011-10-07
Last Modified: 2012-05-12
Report services broke.  We uninstalled and resinstalled but there is an edition change  because the SQl 2005 server is SP3.  How do I bring the new reporting services to the same level of service pack to be able to successfully configure it.  Do I  reapply sp3 to the database  again to bring reporting servcies to the same edition?  Any input appreciated
Question by:Nana Hemaa
    LVL 9

    Accepted Solution

    Yes, you need to apply SP3 to your SSRS database since this is new instance, you just need to select the correct one once you run the service pack
    LVL 39

    Assisted Solution

    "there is an edition change  because the SQl 2005 server is SP3" - that is a version change most likely and not an Edition change.

    You should apply SP3 on all components on all servers involved. What I mean is you need to apply SP3 on your Reporting Service box if SQL Server running the ReportServer and user databases is at SP3 level.

    Author Comment

    by:Nana Hemaa
    did  so ok but in the report server configuration I get reporting services  directory alrady exists so I am not able to get all green check marks on teh configuration page
    LVL 39

    Expert Comment

    Which one(s) are not green?
    LVL 9

    Expert Comment

    If you are able to apply the SP for the Database Services checkbox, that should be enough to have the same version on both instances.

    Author Comment

    by:Nana Hemaa
    ones not green are
    report server virtual directory
    report manager virtual directory
    web servcie identity
    I am trying to use the defaults since I could not do that during installation because of the edition change

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now