Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation

Question

Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation

Vimal Solanki 1

Hi,

I want to upgrade existing SQL Server 2005 Express (SP3) with Advanced Services (x86) ESN (Spanish) to SQL Server 2014 Express Advanced Services.
Before i upgrade I need to patch SQL Server 2005 with SQL Server 2005 Express with advanced Services - Service Pack 4 KB2463332.
The one i downloaded is ENU (English) version and when i try to apply the patch it is unable to proceed further.

I tried to changed the Server OS Language settings from Espana to English but it didnt worked. There is no seperate ESN language SQL 2005 SP4 Express advanced available on the microsoft update site.

Please help to fix this issue.

Thanks,
Vimal

Seeya Xi-MSFT 16,586 Reputation points

2022-11-30T02:50:37.32+00:00

Hi @Vimal Solanki ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

3 answers

Your answer

Seeya Xi-MSFT 16,586 Reputation points

2022-11-30T02:50:37.32+00:00

Hi @Vimal Solanki ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

Answer 1

Guoxiong 8,206

I would try the following steps:

Back up all databases from SQL Server 2005 Express
Install the latest SQL Server Express
Restore the databases from the backup files.

Vimal Solanki 1 Reputation point

2022-11-30T14:01:49.097+00:00

Thanks for your reply.
I'm looking for a direct inplace upgrade instead of SQL 2005 uninstall and install SQL 2014 Express and then restore the databases.
I have many logins and jobs and other dependent items that would require migrating them.

Thanks,
Vimal Solanki

Answer 2

Seeya Xi-MSFT 16,586

Hi @Vimal Solanki ,

There are two main strategies for upgrading: in-place or side-by-side. An in-place upgrade is where you directly replace an older version of SQL Server with a newer version on the same machine and the same instance. A side-by-side upgrade is where you create a new instance of the target version of SQL Server and copy all of the databases, objects, logins, etc. from the source to the new target.
Given that Microsoft has discontinued support for SQL Server 2005, it is recommended that you adopt the approach of side-by-side upgrade.
Backup and restore would be the least risky way to perform the migration. Log shipping is a good option to minimize the amount of downtime. It's basically just backup and restore spread out over time so you only need to restore the final log backup at time of migration.
With log shipping you can have the databases restored on the target SQL Server ahead of migration with NO RECOVERY and continuously restore the Transaction Log backups to the target SQL Server to keep the databases synchronized. When it is time to migrate, the final Transaction Log restore is done with RECOVERY and the databases are brought online.

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Vimal Solanki 1 Reputation point

2022-11-30T13:58:38.327+00:00

Thanks for your reply.

I have the only option is to perform in-place upgrade as we dont want to procure a new server. There are 56 such SQL servers that needs to be upgraded to SQL Server 2014 Express (x86). Thats the reason we want to perform inplace upgrade on each server.
The SQL and OS installation language is Spanish (ESN) and at microsoft site i dont see a seperate SQL 2005 Service pack 4 available in Spanish language. Though i downloaded the available ENU SP4 but it could not proceed further.

:"This update requires language ENU. The language for product instance SQLEXPRESS is ESN. Download the update for language ESN. "
Unfortunately, there is no separate Service pack for SQL 2005 SP4 available for Spanish language.

I observed on one of the server where SQL 2005 SP4 ESN is installed and could see the log file where the setup used was Spanish one instead of English.
Unfortunately, that setup file is not available on that server.

Appreciate your help.

Thanks,
Vimal Solanki
Seeya Xi-MSFT 16,586 Reputation points

2022-12-01T09:04:08.97+00:00

Hi @Vimal Solanki ,

Because SQL Server 2005 is so old and unsupported, the download links may not be as comprehensive. You can upgrade to a newer version first and then install the patch. At that time, you will be able to see where to select the language.
Like this:

Best regards,
Seeya

------------------------------------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it.
Vimal Solanki 1 Reputation point

2022-12-01T18:08:25.267+00:00

Thank you Seeya.

Our existing SQL 2005 servers are running on SP2 / SP3. The pre-requisite is to have SQL 2005 SP4 installed prior to upgrading to SQL 2014, that's the caveat. The setup fails during initial step of 2014 upgrade installation.

Best Regards,
Vimal
Seeya Xi-MSFT 16,586 Reputation points

2022-12-05T08:36:20.79+00:00

Hi @Vimal Solanki ,

In fact, SQL Server 2005 is really too old and there is no official download link anymore. So, it makes me wonder if your machine's operating system is also very old.
You can refer to this document and check if the conditions for installing SQL Server 2014 are met.
https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
If the conditions are not met, it is recommended that you purchase a new machine.

Best regards,
Seeya

Answer 3

Olaf Helper 47,436

existing SQL Server 2005 Express (SP3) with Advanced Services (x86)

As I wrote at https://techcommunity.microsoft.com/t5/sql-server-engine/unable-to-apply-sql-server-2005-sp4-enu-on-sql-2005-esn/m-p/3687697
You have a x86 = 32 bit SQL Server and in-place upgrade can only be done to a 32 bit SQL Server 2014; do you really want to go with 32 bit?

Share via

Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation

3 answers

Your answer