I am failing to install SQL Server 2022 because of a missing RegEntry file, Im getting this error 'Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\160\ConfigurationState'.

Question

I am failing to install SQL Server 2022 because of a missing RegEntry file, Im getting this error 'Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\160\ConfigurationState'.

Dave Budah 5

Screenshot 2023-09-05 133505

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-06T21:42:00.4866667+00:00

In that folder in the screenshot there are lots of log files. The ones of primary interest are summary.txt and details.txt. Maybe there are some more hints there?

Dave Budah 5

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068052377
  Start time:                    2023-09-07 00:57:18
  End time:                      2023-09-07 00:57:41
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.


Machine Properties:
  Machine name:                  DAVE
  Machine processor count:       8
  OS version:                    Microsoft Windows 11 Pro (10.0.22621)
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured

Package properties:
  Description:                   Microsoft SQL Server 2022 
  ProductName:                   SQL Server 2022
  Type:                          RTM
  Version:                       16
  SPLevel:                       0
  Installation location:         C:\SQL2022\Developer_ENU\x64\setup\
  Installation edition:          Developer

Product Update Status:
  User selected not to include product updates.

Notice: Please read Microsoft SQL Server Software License Terms at aka.ms/useterms.

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      false
  AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  TABULAR
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 <empty>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTELSVCACCT:                  <empty>
  ASTELSVCPASSWORD:              <empty>
  ASTELSVCSTARTUPTYPE:           0
  ASTEMPDIR:                     Temp
  AZUREARCPROXYSERVER:           <empty>
  AZUREBILLEDEDITION:            
  AZUREREGION:                   <empty>
  AZURERESOURCEGROUP:            <empty>
  AZURESERVICEPRINCIPAL:         <empty>
  AZURESERVICEPRINCIPALSECRET:   <empty>
  AZURESUBSCRIPTIONID:           <empty>
  AZURETENANTID:                 <empty>
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230907_005718\ConfigurationFile.ini
  ENABLERANU:                    false
  ENU:                           true
  EXTSVCACCOUNT:                 <empty>
  EXTSVCPASSWORD:                <empty>
  FEATURES:                      SQLENGINE
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  true
  IACKNOWLEDGEENTCALLIMITS:      false
  INDICATEPROGRESS:              true
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISMASTERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISMASTERSVCPASSWORD:           <empty>
  ISMASTERSVCPORT:               8391
  ISMASTERSVCSSLCERTCN:          <empty>
  ISMASTERSVCSTARTUPTYPE:        Automatic
  ISMASTERSVCTHUMBPRINT:         <empty>
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  ISTELSVCACCT:                  <empty>
  ISTELSVCPASSWORD:              <empty>
  ISTELSVCSTARTUPTYPE:           0
  ISWORKERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISWORKERSVCCERT:               <empty>
  ISWORKERSVCMASTER:             <empty>
  ISWORKERSVCPASSWORD:           <empty>
  ISWORKERSVCSTARTUPTYPE:        Automatic
  NPENABLED:                     0
  PBDMSSVCACCOUNT:               <empty>
  PBDMSSVCPASSWORD:              <empty>
  PBDMSSVCSTARTUPTYPE:           0
  PBENGSVCACCOUNT:               <empty>
  PBENGSVCPASSWORD:              <empty>
  PBENGSVCSTARTUPTYPE:           0
  PBPORTRANGE:                   <empty>
  PID:                           *****
  PRODUCTCOVEREDBYSA:            false
  QUIET:                         true
  QUIETSIMPLE:                   false
  ROLE:                          
  SAPWD:                         <empty>
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLMAXDOP:                     8
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCINSTANTFILEINIT:         true
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           DAVE\ABSP-DEV
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY
  SQLTELSVCPASSWORD:             <empty>
  SQLTELSVCSTARTUPTYPE:          Automatic
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBFILECOUNT:            8
  SQLTEMPDBFILEGROWTH:           64
  SQLTEMPDBFILESIZE:             8
  SQLTEMPDBLOGDIR:               <empty>
  SQLTEMPDBLOGFILEGROWTH:        64
  SQLTEMPDBLOGFILESIZE:          8
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SUPPRESSPAIDEDITIONNOTICE:     false
  SUPPRESSPRIVACYSTATEMENTNOTICE: false
  TCPENABLED:                    0
  UIMODE:                        Normal
  UpdateEnabled:                 false
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false
  USESQLRECOMMENDEDMEMORYLIMITS: false

  Configuration file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230907_005718\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          1639
  Component log file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230907_005718\sql_engine_core_inst_Cpu64_1.log
  Error description:             Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639

  Feature:                       SQL Browser
  Status:                        Passed

  Feature:                       SQL Writer
  Status:                        Passed

Rules with failures or warnings:

Global rules:
Warning    IsFirewallEnabled                The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2162127 for information about ports to open for each feature.

Rules report file:               C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230907_005718\SystemConfigurationCheck_Report.htm

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-07T21:00:09.4933333+00:00

We also need detail.txt. And please do not include it in the post, but attach the file. That file is very long and verbose.

2 answers

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-06T21:42:00.4866667+00:00

In that folder in the screenshot there are lots of log files. The ones of primary interest are summary.txt and details.txt. Maybe there are some more hints there?
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-07T21:00:09.4933333+00:00

We also need detail.txt. And please do not include it in the post, but attach the file. That file is very long and verbose.

Answer 1

Hi @Dave Budah,

Please try to launch the SQL Server Setup program (setup.exe) as administrator from SQL Server installation media-> Maintenance in the left-hand navigation area-> Repair. User's image

You can try to uninstall and reinstall.
Here are the steps to uninstall cleanly.

Remove all SQL Server components from 'Programs and Features'
Backup the registry
Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
Reboot the machine
In addition, please use an administrator account to reinstall SQL Server on your computer (Right click->run as administrator).

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Dave Budah 5 Reputation points

2023-09-06T14:03:37.78+00:00

Thanks for the suggestion. I have done this several times but to no avail. I guess I have to make peace with not being able to use this SQL Server on my current machine.

Answer 2

Nick B 5

So, I had issues when installing MS SQL Server Express 2022. I followed guides and everything on how to get it installed, etc. All that did was introduce other problems.

Eventually, I ran into this error:

"Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\160\ConfigurationState'"

Which is how I ended up here. Nothing worked that was recommended.

My Solution:

I downloaded a VM, installed windows 10, installed MS SQL Server 2022, then copied and exported the ConfigurationState reg key.

Guess what? It worked flawless.

Hope this helps someone else.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-12-20T22:05:40.6433333+00:00

Creative!
Ira Fuchs 0 Reputation points

2024-03-03T16:07:02.2233333+00:00

I have the same problem (same error). Can this be fixed without resorting to creating another instance of MS SQL Server and copying the configurationstate key?
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-03-03T18:11:33.31+00:00

For what it's worth, this is what I have on my machine:

But I can't guarantee that it will work on your machine.

Overall, we don't like piggybacking on old threads, so if you run into more problems it is better to post a new Question, describing your problem from start to end.

Share via

I am failing to install SQL Server 2022 because of a missing RegEntry file, Im getting this error 'Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\160\ConfigurationState'.

2 answers

Your answer