Unable to upgrade existing SQL Server 2005 instance(CSSQL05) to Service Pack 4.Error: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server

Unable to upgrade existing SQL Server 2005 instance(CSSQL05) to Service Pack 4. Error:
Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

When trying to upgrade the CSSQL05 instance to the latest release(SQL Server 2005 Express Advanced SP4 version 9.0.5000) you need to take the following into consideration:

- Since Cambridgesoft provide the Express Advanced version of SQL you won't be able to complete the upgrade with the Standard release.

- The normal version of SQL Server 2005 Express SP4 will also fail, you need to download the package from here:

http://www.microsoft.com/en-us/download/details.aspx?id=184
* Make sure to select the package called SQLEXPR_ADV.EXE

- If you don't download the right package it's impossible to complete the upgrade, not even with the "Template.ini" file or with parameters through the Command Line Interface to execute the setup.exe with the options provided by Microsoft, it will fail.

This upgrade is necessary when restoring databases from SQL Server 2005 SP4(9.0.5000) and you have an older service pack on your PC. If you just create a new SP4 instance as a workaround then you will have to add the "Full Text Serch" feature required by Enotebook database. So, it's easier to upgrade your CSSQL05 instance (created with the installer of ChemBioOffice) than configure the new SP4 instance manually.