We help IT Professionals succeed at work.

SQL 2005 Evaluation Period Expired

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.
Cheers.
Comment
Watch Question

Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
<off topic>
I'd heavily counsel the individual that installed an evaluation license on a production server, then ran production processes on it.
kfdiabSr. Systems Engineer

Author

Commented:
How could that help? I need a solution for my problem. Currently the Central server is down.
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
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.
EvilPostItIT Director
CERTIFIED EXPERT

Commented:
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.
SQL Server Architect
CERTIFIED EXPERT
Commented:
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.