Tuesday, March 27, 2012

convert 180-day version of sql

I need to find out what steps to take to convert the 180-day version of sql server 2005. My server has Microsoft Small Business Server 2003 Premium installed.What do you want to install instead ? Make sure you have the correct licences in place.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

If you have the correct licensing and are looking for the technical answer, the trick is to use the SKUUPGRADE=1 flag during upgrade. Take a look at template.ini or Books Online for more info. Here is a forums snippet that I can't seem to find on MSDN at the moment, but it should get you started.

If you have already expired with your existing version, take a look at this article:
http://support.microsoft.com/kb/914158/en-us

Thanks,
Sam Lester (MSFT)

[SKUUPGRADE]

Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server 2005 to another edition of SQL Server 2005.

Important:

If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.

To perform an edition upgrade of a default instance of SQL Server 2005 (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

No comments:

Post a Comment