Unable to Install SQL server 2022

Question

Unable to Install SQL server 2022

Owen Patrick 20

Screenshot 2023-09-26 164140

Got this error while trying to install SQL Server 2022 Express edition. I restarted my laptop and tried again, still no luck. Also checked the summary log in the installation folder and the only info I can get from it is that I need a valid copy of the installation package 'msodbcsql_17.5.1.1_x64.msi'. Not sure where to go from here. Any help would be greatly appreciated!

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-26T21:21:22.1066667+00:00

Have you checked if you already have some version of ODBC Driver 17 installed? I've seen people running into this error before, but not really understood what is going on. But I guess checking for a conflicting installation is a start.

Another idea is to install the driver before you install SQL Server.

Owen Patrick 20

Hey, thanks for responding and giving some suggestions. I looked and could not find another version of the ODBC Driver 17. I also tried installing the driver itself before installing SQL Server. Neither solutions worked sadly.

After more research and troubleshooting I ended up downloading SMSS 19 and adding an inbound rule to my firewall. Now all of a sudden I get this error message instead (I'm pasting the whole summary from the installation log):

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2147467259
  Start time:                    2023-09-26 22:06:31
  End time:                      2023-09-26 22:08:02
  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, uninstall this feature, and then run the setup process again.


Machine Properties:
  Machine name:                  LAPTOP-9I157COP
  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
  SQL Server 2022      SQLEXPRESS           MSSQL16.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      16.0.1000.6     No         Yes       
  SQL Server 2022      SQLEXPRESS01         MSSQL16.SQLEXPRESS01           Database Engine Services                 1033                 Express Edition      16.0.1000.6     No         Yes       
  SQL Server 2022      SQLEXPRESS02         MSSQL16.SQLEXPRESS02           Database Engine Services                 1033                 Express Edition      16.0.1000.6     No         Yes       

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

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:      true
  AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Disabled
  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\20230926_220631\ConfigurationFile.ini
  ENABLERANU:                    true
  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:                    SQLEXPRESS03
  INSTANCENAME:                  SQLEXPRESS03
  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:                          AllFeatures_WithDefaults
  SAPWD:                         <empty>
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLMAXDOP:                     0
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS03
  SQLSVCINSTANTFILEINIT:         true
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           LAPTOP-9I157COP\owenp
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SQLEXPRESS03
  SQLTELSVCPASSWORD:             <empty>
  SQLTELSVCSTARTUPTYPE:          Automatic
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBFILECOUNT:            1
  SQLTEMPDBFILEGROWTH:           64
  SQLTEMPDBFILESIZE:             8
  SQLTEMPDBLOGDIR:               <empty>
  SQLTEMPDBLOGFILEGROWTH:        64
  SQLTEMPDBLOGFILESIZE:          8
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SUPPRESSPAIDEDITIONNOTICE:     false
  SUPPRESSPRIVACYSTATEMENTNOTICE: false
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  UpdateEnabled:                 false
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false
  USESQLRECOMMENDEDMEMORYLIMITS: false

  Configuration file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230926_220631\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, uninstall this feature, and then run the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x80004005
  Error description:             The system cannot find the path specified
  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=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325

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\20230926_220631\SystemConfigurationCheck_Report.htm

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-27T20:52:43.2366667+00:00

We would need to see details.txt to understand which file/path that is missing.
Owen Patrick 20 Reputation points

2023-09-27T22:40:08.86+00:00

Thanks Erland- I ended up fixing it by uninstalling all the failed installations using the link provided below. Cheers!
Minas Kotsis 0 Reputation points

2025-02-22T09:41:08.3066667+00:00

I am using parallels on a Mack M2 laptop but cannot install SQL

Accepted answer

0 additional answers

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-26T21:21:22.1066667+00:00

Have you checked if you already have some version of ODBC Driver 17 installed? I've seen people running into this error before, but not really understood what is going on. But I guess checking for a conflicting installation is a start.

Another idea is to install the driver before you install SQL Server.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-09-27T20:52:43.2366667+00:00

We would need to see details.txt to understand which file/path that is missing.
Owen Patrick 20 Reputation points

2023-09-27T22:40:08.86+00:00

Thanks Erland- I ended up fixing it by uninstalling all the failed installations using the link provided below. Cheers!
Minas Kotsis 0 Reputation points

2025-02-22T09:41:08.3066667+00:00

I am using parallels on a Mack M2 laptop but cannot install SQL

Answer 1

Hi @Owen Patrick

The error message "The system cannot find the path specified" indicates that certain files of SQL Server Basic Components cannot be located. The files may be corrupted or access to the files may be denied.

Please follow the steps in the blog Cleanly Uninstall Stubborn SQL Server Components to uninstall and then reinstall SQL Server. You can refer to this thread: https://learn.microsoft.com/en-us/answers/questions/263964/unable-to-install-sql-server-(setup-exe)-exit-code.

For the error "An installation package for the product Microsoft ODBC Driver 17 for SQL Server cannot be found", you can refer to this thread: https://learn.microsoft.com/en-us/answers/questions/1083390/sql-server-2019-installation-failed-with-206805231.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Owen Patrick 20 Reputation points

2023-09-27T22:38:30.0066667+00:00

Thank you so much! Cleanly uninstalling all the failed installations using the instructions you provided worked. I did that and then installed sql server again as an administrator and it works now.

Share via

Unable to Install SQL server 2022

0 additional answers

Your answer