Language problem when upgrading SQL Server

Jaime Stuardo 56

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:

Language error

How can I solve it?

Thanks
Jaime

8 answers

CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2021-03-17T08:41:21.803+00:00

Hi anonymous usertuardo-7580,

> 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?

Yes, it is possible. Migrate SQL server 2017 to a new instance, then cleanly uninstall old SQL server 2017. You can backup all the databases and copy the full backups to the target and restore them there. Or detach the databases from the source and attach them to the target.

Refer to the blog A Faster Way to Migrate SQL Server Instances to get more.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Jaime Stuardo 56 Reputation points

2021-03-17T11:02:48.347+00:00

I mean, to remove SQL Server 2017 instance first. The reason is because if I migrate to other instance, that instance will not be the default. That will case I will need to specify the instance name when I connect to it. By specifying the machine name will not be enough.
Please sign in to rate this answer.
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2021-03-18T01:47:46.557+00:00

Hi anonymous usertuardo-7580,

Yes, you need to type computer name\ instance name in the server name box when connecting named SQL server instance.

If you want to uninstalled the SQL server first. What can you do to recover the SQL server instance, when the migration failed and the backup files corrupt? I just worry about this situation.

Jaime Stuardo 56 Reputation points

2021-03-22T19:51:10.703+00:00

Don't worry about that. I remember I did the same with an older SQL Server version. I did not need to detach first. I have removed an engine and then, after installed a new one (using the same default name), I attached all databases one by one. It was possible, with those versions at least.

Regards,
Jaime
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Reza Akhavan 0 Reputation points

2023-07-11T00:47:13.4066667+00:00

Hi

pls, close the sql server installer, and try again.

The prob. will solve.

regards
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Language problem when upgrading SQL Server

8 answers

Your answer