question

HenrikLarson-9034 avatar image
0 Votes"
HenrikLarson-9034 asked HenrikLarson-9034 answered

Error upgrading SQL Server 2012 to SQL Server 2017 using command line

I try to upgrade a SQL Server 2012 SP4 instance to SQL Server 2017 on Windows 10 using the command line. I get the error below. Searching for the problem gives hints about changing the system locale, but I already have en-US in Windows and the same SQL 2017 setup.

If I run the same setup with user interface it works fine, but I need to use the command line.


PS C:\sql2017\SQLEXPR_2017_x64_ENU> Get-WinSystemLocale

LCID Name DisplayName


1033 en-US English (United States)


PS C:\sql2017\SQLEXPR_2017_x64_ENU> .\SETUP.EXE /Action=Patch /AllInstances
Microsoft (R) SQL Server 2017 14.00.1000.169
Copyright (c) 2017 Microsoft. All rights reserved.

The following error occurred:
The SQL Server license agreement cannot be located for the selected edition, EXPRESS. This could be a result of corrupted media or the edition being unsupported by the media.

Error result: -2054422501
Result facility code: 1420
Result error code: 27

Please review the summary.txt log for further details
PS C:\sql2017\SQLEXPR_2017_x64_ENU>

sql-server-generalsql-server-migration
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please review the summary.txt log for further details

And, have you done what the message suggest? Do you see any helpful details in the log file?

0 Votes 0 ·

Below is the summary file. I can not find any helpful hint in it.


Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2054422501
Exit facility code: 1420
Exit error code: 27
Exit message: The SQL Server license agreement cannot be located for the selected edition, EXPRESS. This could be a result of corrupted media or the edition being unsupported by the media.
Start time: 2021-08-19 20:20:25
End time: 2021-08-19 20:20:33
Requested action: ComponentUpdate

Machine Properties:
Machine name: DESKTOP-MEIS91R
Machine processor count: 2
OS version: Microsoft Windows 10 Pro (10.0.18362)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Package properties:
Description: Microsoft SQL Server 2017
ProductName: SQL Server 2017
Type: RTM
Version: 14
SPLevel: 0
Installation location: C:\sql2017\SQLEXPR_2017_x64_ENU\x64\setup\
Installation edition: Express

0 Votes 0 ·

User Input Settings:
ACTION: ComponentUpdate
CONFIGURATIONFILE:
ENU: true
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
INDICATEPROGRESS: false
MRCACHEDIRECTORY:
PID: *
QUIET: false
QUIETSIMPLE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: AutoAdvance
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20210819_202024\ConfigurationFile.ini

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: The rule result report file is not available.

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

0 Votes 0 ·
Show more comments
HenrikLarson-9034 avatar image
0 Votes"
HenrikLarson-9034 answered

Okay, I thing I have found my problem. The action "Patch" will update SQL Server, but I want to upgrade my SQL Server and need to use the action "Upgrade". This command line worked for me:

setup.exe /QS /ACTION=UPGRADE /INSTANCENAME=Test /IACCEPTSQLSERVERLICENSETERMS

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft edited

Hi @HenrikLarson-9034,

This error is probably caused by a corrupted media as mentioned on the error message. Please try to download:
https://www.microsoft.com/en-us/download/details.aspx?id=55994

and please verify that the following operating system settings match the language of the localized SQL Server to be installed:
The operating system user interface setting
The operating system user locale setting

https://docs.microsoft.com/en-us/sql/sql-server/install/local-language-versions-in-sql-server?view=sql-server-ver15#BK_ConfigureOS

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HenrikLarson-9034 avatar image
0 Votes"
HenrikLarson-9034 answered

@Yufeishao-msft thanks for your reply.

First, isn't the English-US SQL setup supposed to be possible to use on all operating systems. The link in your post tells that:

  • The English-language version of SQL Server is supported on all localized versions of operating systems.

All language settings on the computer are set to English:

125054-language1.png


125007-language2.png


125034-language3.png

Finally I downloaded SQL 2017 setup again and tested with the same error. I also downloaded SQL 2019 and get the same error.



language1.png (7.8 KiB)
language2.png (11.6 KiB)
language3.png (15.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.