What are the recommendations for upgrading the SQL Server application from SQL Server 2000 to SQL Server 2005 or SQL Server 2008 with LiteSpeed installed?
Server running LiteSpeed has been upgraded from Microsoft SQL Server 2000 to SQL Server 2005 or SQL Server 2008.
LiteSpeed should be uninstalled when performing the upgrade from SQL Server 2000 to SQL 2005 or 2008 and reinstalled when the SQL Server 2005 upgrade is complete. Rebooting the system upon the installation of LiteSpeed is not required.
The LiteSpeed License key will remain intact.
To uninstall LiteSpeed (Versions 4.x):
Option 1:
If you have the LiteSpeed2005.msi installer available and used it to install the LiteSpeed application, run it again. If the same version is installed, the application will prompt the user to uninstall the application.
Option 2:
Use the 'Add and Remove Programs' windows utility under Control Panel to uninstall the application.
Option 3:
Use uninstall string from the following path in regedit:
//HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
Find LiteSpeed from the list of GUIDs and double-click on the 'UninstallString', The 'Edit String' window will appear. Copy the 'Value data' into a command prompt. This will start the uninstall process. This is the same process that is run during Add/Remove programs from Control Panel.
Per Microsoft TechNet, there may be additional utilities to be run on SQL Server once the update is complete. For additional info, see: http://technet.microsoft.com/en-us/library/ms188414.aspx
