Language problem when upgrading SQL Server

Question

Hello.

My scenario:

• SQL Server 2017 in English
• Windows 10 in Spanish

I want to upgrade SQL Server 2017 to SQL Server 2019 also in English, without uninstalling SQL Server 2017 first.

I have used the option to upgrade in the setup wizard. However, this error occurs:

How can I solve it?

Thanks
Jaime

Answer 1

Hi anonymous usertuardo-7580,

> Rule "cross language installation: failed. the Setup language is different than the language of SQL Server features you are upgrading. To continue, use SQL Server Setup installation media of the same language as the installed SQL Server features.

Please check if the language of SQL Server features that you installed are same, you can get this from SQL server summary setup log. Refer to View and Read SQL Server Setup Log Files. Or you can check this from Microsoft SQL Server 2019 Setup Discovery Report. In SQL Server Installation Center click on Tools on the left pane and click on “Installed SQL Server features Discovery Report”.

If they are same(such as 1033 means English, 3082 means Spanish), please try to restart the setup and install again. Then share us the result.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
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.

Answer 2

Hello, I have used the discovery report and this was the result:

As you see, first 2 features have both English and Spanish versions. Third feature only English and the last 3, only Spanish. I think those 3 features are the problem, aren't they?

I don't know why those features were installed in Spanish only. How can I remove only those before installing SQL Server 2019?

Thanks
Jaime

Answer 3

Hi anonymous usertuardo-7580,

> I don't know why those features were installed in Spanish only.

They are all shares features. I think you installed Spanish version SQL server first, then you installed English version SQL server.

Suggest you uninstalled Spanish version SQL server. Then upgrade English version SQL server 2017 to SQL 2019.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 4

Hello,

how can I uninstall a version that I have never installed? Since SQL Server 2000, I use always to install English versions, unless other program has installed it without my knowledge.

Answer 5

There is no other instance, and as I told you, I have never installed Spanish version, but independent of that, if it was installed somehow, how can I uninstall only spanish version? That is the actual question. I have launched SQL Server 2017 Installation Center but I did not find a way to do that.

Or, if it is not possible. Can I safely uninstall SQL Server 2017 completely and then copy all MDF and LDF files to the new DATA folder to have all databases in the new instance?