SQL 2005 Evaluation Period Expired

Posted on 2012-08-14
Medium Priority
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 66

Expert Comment

by:Jim Horn
ID: 38291759
<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

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

Expert Comment

by:Jim Horn
ID: 38292081
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

ID: 38292294
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 25

Accepted Solution

DBAduck - Ben Miller earned 1050 total points
ID: 38293452
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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 extract information from SQL Server on Database, Connection and Server properties

587 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