SQL 2005 Evaluation Period Expired

Posted on 2012-08-14
Last Modified: 2012-09-02
Dear All,

I have a CD for SQL 2005 installation and I a separate one for SQL 2005 SP3, does anyone knows how can I integrate both the installation and service pack in one Installation setup CD?
I have a problem with one of my servers, it appeared that one of the engineers installed SQL 2005 Enterprise Evaluation Edition and evaluation period is now expired. I need to perform an upgrade, but it is preventing me from doing so since the installed SQL has the SP3 installed and the CD I am using does not have the SP3 integrated in it.
I am also not capable of finding a CD with the SP3 integrated in it. I also cannot uninstall the SP3, since there is no way to do so.
The only option I have is that I will uninstall SQL 2005 from the server and reinstall it again, but this will cause me a problem in the replication to the other SQL servers located at the branches.
Please can anyone help?
Appreciate it.
Question by:kfdiab
    LVL 65

    Expert Comment

    by:Jim Horn
    <off topic>
    I'd heavily counsel the individual that installed an evaluation license on a production server, then ran production processes on it.

    Author Comment

    How could that help? I need a solution for my problem. Currently the Central server is down.
    LVL 65

    Expert Comment

    by:Jim Horn
    The one time I had to deal with this I ended up doing a full un-install, then re-install of the Enterprise license, so I don't have a solution for you.

    I'll unmonitor the question now to encourage others to respond.

    Good luck.
    LVL 16

    Expert Comment

    I agree with Jim Horn. You will need to un-install and re-install. The only way you can intermix a service pack with the SQL Server install CD is by doing a slipstream install. Unfortunately slipstream installs are not available in SQL Server 2005, just 2008 onwards.

    You will have to remove and re-create the replication setup.
    LVL 24

    Accepted Solution

    You will need to do a complete uninstall and reinstall.  That is the way it works with 2005 and below. 2008 allowed slipstream as was indicated above.  If you uninstall and reinstall, but put the system databases and all the other databases back in the same places you should not have to re-setup anything.  But to minimize the work after reinstall, you will need to uninstall and move the databases off to another directory, reinstall SQL Server to the same place with the folders for the system databases and other databases the same as were before.  Then upgrade to SP3, then replace all the new databases with the original databases, system and user, and then start SQL Server.

    You should be good to go then.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now