Forum Discussion

cocka13's avatar
cocka13
Copper Contributor
Sep 18, 2024

Instalation problem SQLServer 2019/2022 on Win11Pro

Hi everyone,

I'm writing here for the first time because I ran out of ideas.

I had a working SQLServer Express 2019 (CU13) on Win10Pro machine. For educational and development purposes, local instalation, nothinng special.

Recently, I upgraded Win10Pro to Win11Pro. The SQLServer service stopped working immediately. I tried everything to start the service but no luck.

 

The next thing I tried was uninstall SQLServer2019 and install new one (2022 and 2019, same thing). At the end of the instalation, both give me the same error:

TITLE: Microsoft SQL Server 2022 Setup
------------------------------

The following error has occurred:

The filename, directory name, or volume label syntax is incorrect.

 

Error code: 0x84BB0001

I searched all over the Internet and tried:

  • Uninstall SQLServer and all components, delete all folders related with SQLServer
  • Clean the registry keys and values related to SQLServer manually and check with CCleaner
  • Check fsutil fsinfo sectorinfo C:, and it is fine (512/4096)
  • Tried sfc, d*ism, chkdsk - all ok
  • Download new ISO installation (2022 and 2019), mount
  • setup.exe - Run as Administrator
  • Disable firewall, antivirus, Defender
  • Tried installing under the default directory name and the short one, changed instance name
  • Create new local admin user and install under the new user

Nothing helps. The error is the same whatever I do or install 2019 or 2022 version.

Checked error log - can't find anything to guide me to the solution.

 

Checked Global Rules - it's fine

 

The SSD that I have is (the same SSD as on Win10 where everything worked):

SCSI\DiskNVMe____SAMSUNG_MZALQ512HBLU-00BL27L2QFXM7
SCSI\DiskNVMe____SAMSUNG_MZALQ512HBLU-00BL2
SCSI\DiskNVMe____SAMSUNG_MZALQ512FXM7
SCSI\DiskNVMe____SAMSUNG_MZALQ512
SCSI\DiskNVMe____
SCSI\NVMe____SAMSUNG_MZALQ512F
NVMe____SAMSUNG_MZALQ512F
GenDisk

 

...any ideas?

 

TIA

Mladen

4 Replies

  • MisteRO1322's avatar
    MisteRO1322
    Copper Contributor

    I've run into the same issue on two different machines. Were you ever able to resolve this?

  • cocka13's avatar
    cocka13
    Copper Contributor

    cocka13 

    I cannot upload files on this forum?

    So, here is Summary...

    Overall summary:
    Final result: Failed: see details below
    Exit code (Decimal): -2068119551
    Start time: 2024-09-18 10:22:26
    End time: 2024-09-18 10:32:26
    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: MLADEN-NB
    Machine processor count: 16
    OS version: Microsoft Windows 11 Pro (10.0.22631)
    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 2019
    ProductName: SQL Server 2019
    Type: RTM
    Version: 15
    SPLevel: 0
    Installation location: E:\x64\setup\
    Installation edition: Express

    Product Update Status:
    None discovered.

    User Input Settings:
    ACTION: Install
    ADDCURRENTUSERASSQLADMIN: false
    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
    BROWSERSVCSTARTUPTYPE: Disabled
    CLTCTLRNAME: <empty>
    CLTRESULTDIR: <empty>
    CLTSTARTUPTYPE: 0
    CLTSVCACCOUNT: <empty>
    CLTSVCPASSWORD: <empty>
    CLTWORKINGDIR: <empty>
    COMMFABRICENCRYPTION: 0
    COMMFABRICNETWORKLEVEL: 0
    COMMFABRICPORT: 0
    CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20240918_102155\ConfigurationFile.ini
    CTLRSTARTUPTYPE: 0
    CTLRSVCACCOUNT: <empty>
    CTLRSVCPASSWORD: <empty>
    CTLRUSERS: <empty>
    ENABLERANU: true
    ENU: true
    EXTSVCACCOUNT: <empty>
    EXTSVCPASSWORD: <empty>
    FEATURES: SQLENGINE
    FILESTREAMLEVEL: 0
    FILESTREAMSHARENAME: <empty>
    FTSVCACCOUNT: <empty>
    FTSVCPASSWORD: <empty>
    HELP: false
    IACCEPTPYTHONLICENSETERMS: false
    IACCEPTROPENLICENSETERMS: false
    IACKNOWLEDGEENTCALLIMITS: false
    INDICATEPROGRESS: false
    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: SQLEXPRESS
    INSTANCENAME: SQLEXPRESS
    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
    MATRIXCMBRICKCOMMPORT: 0
    MATRIXCMSERVERNAME: <empty>
    MATRIXNAME: <empty>
    MRCACHEDIRECTORY:
    NPENABLED: 0
    PBDMSSVCACCOUNT: <empty>
    PBDMSSVCPASSWORD: <empty>
    PBDMSSVCSTARTUPTYPE: 0
    PBENGSVCACCOUNT: <empty>
    PBENGSVCPASSWORD: <empty>
    PBENGSVCSTARTUPTYPE: 0
    PBPORTRANGE: <empty>
    PBSCALEOUT: false
    PID: *****
    QUIET: false
    QUIETSIMPLE: false
    ROLE:
    RSINSTALLMODE: DefaultNativeMode
    RSSVCACCOUNT: <empty>
    RSSVCPASSWORD: <empty>
    RSSVCSTARTUPTYPE: Automatic
    SAPWD: *****
    SECURITYMODE: SQL
    SQLBACKUPDIR: D:\SQLServer\SQL_Backup
    SQLCOLLATION: Croatian_CI_AS
    SQLJAVADIR: <empty>
    SQLMAXDOP: 0
    SQLMAXMEMORY: 2147483647
    SQLMINMEMORY: 0
    SQLSVCACCOUNT: NT Service\MSSQL$SQLEXPRESS
    SQLSVCINSTANTFILEINIT: false
    SQLSVCPASSWORD: <empty>
    SQLSVCSTARTUPTYPE: Automatic
    SQLSYSADMINACCOUNTS: MLADEN-NB\Mladen
    SQLTELSVCACCT: NT Service\SQLTELEMETRY$SQLEXPRESS
    SQLTELSVCPASSWORD: <empty>
    SQLTELSVCSTARTUPTYPE: Automatic
    SQLTEMPDBDIR: <empty>
    SQLTEMPDBFILECOUNT: 1
    SQLTEMPDBFILEGROWTH: 64
    SQLTEMPDBFILESIZE: 8
    SQLTEMPDBLOGDIR: <empty>
    SQLTEMPDBLOGFILEGROWTH: 64
    SQLTEMPDBLOGFILESIZE: 8
    SQLUSERDBDIR: D:\SQLServer\SQL_Data
    SQLUSERDBLOGDIR: D:\SQLServer\SQL_Log
    SUPPRESSPAIDEDITIONNOTICE: false
    SUPPRESSPRIVACYSTATEMENTNOTICE: false
    TCPENABLED: 0
    UIMODE: Normal
    UpdateEnabled: true
    UpdateSource: MU
    USEMICROSOFTUPDATE: false
    USESQLRECOMMENDEDMEMORYLIMITS: false
    X86: false

    Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20240918_102155\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: 0x84BB0001
    Error description: The filename, directory name, or volume label syntax is incorrect.
    Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x476BF04A%400xDC80C325&EvtType=0x476BF04A%400xDC80C325

    Feature: SQL Browser
    Status: Passed

    Feature: SQL Writer
    Status: Passed

    Feature: SQL Client Connectivity SDK
    Status: Passed

    Feature: SQL Client Connectivity
    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=2094702 for information about ports to open for each feature.

    Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20240918_102155\SystemConfigurationCheck_Report.htm

    • SivertSolem's avatar
      SivertSolem
      Iron Contributor

      Examining your parameters, the only things I can put a finger on is:

      1. You've located several files on D:\, and haven't shown if that volume exists
        1. If Volume exist, SQL Server installation is unable to use a directory with files in it as a data/log directory
      2. /INSTALLSQLDATADIR, /SQLTEMPDBDIR and /SQLTEMPDBLOGDIR are all"<empty>", which I suspect is the actual "incorrect syntax".
        1. In other words, you haven't configured the installation location of SQL Server itself.
        2. EDIT: This is not the issue, when not set, defaults are used.
    • jlthomas12's avatar
      jlthomas12
      Copper Contributor

      Running into this issue as well.  Was there ever any resolution?

Resources