SQLExpress 2017 upgrade to SQLExpress 2019 fails with message "Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available"

Kevin Wang 1 Reputation point
2020-08-25T16:51:08.59+00:00

20573-summary.txtI am trying to upgrade my SQLExpress 2017 to SQLExpress 2019. It failed due to Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available. It looks like failed to open, create and copy registry between SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14XXXXX and SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15XXXX.

I appreciate if anyone know what's the problem and know how to resolve it.

Here are the log details:

20228-detail-local.txt

If the upgrade succeeded we should see below logs instead of "Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC." and "More data is available".

(01) 2020-08-26 17:10:10 Slp: CopyTo: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.SQLEXPRESSXXXX\MSSQLServer\Parameters, Destination = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.SQLEXPRESSXXXX\MSSQLServer

I checked the permission at the registry keys, no difference to the other test environments where I used another custom root dir created manually and that upgrade succeeded.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,672 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2020-08-26T02:53:38+00:00

    Hi KevinWang-8447,

    Please make sure the account used for installation have enough permission to edit registry. Please refer to this article which might help.
    In addition, could you please share us the summary setup log?

    Best Regards,
    Amelia


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.