I Can´t install SQL Server Express 2019 in Windows 11

Nrosario98 20 Reputation points
2023-01-30T06:48:32.5766667+00:00

Good night. I ask for your help to solve the following problem (my english is very bad):

When I try to install SQL Server 2019 Express on Windows 11, it gets stuck on SqlEngineConfigAction_install_confignonrc_Cpu64.

I already tried running the following command for cmd but it didn't work: reg add "HKLMSYSTEMCurrentControlSetServicesstornvmeParametersDevice" /v "ForcedPhysicalSectorSizeInBytes" /t reg_multi_sz /d "4095" /f*

However, I did the installation on another Windows 10 laptop and had no problems.

I thank you for your cooperation.

SQL Server Other
{count} votes

6 answers

Sort by: Most helpful
  1. Danny Hollis 75 Reputation points
    2023-03-03T13:41:20.2266667+00:00

    After so much pain, I found this to simply be a caused by a third party anti-virus (Kaspersky). I disabled for 5 mins and installed successfully.

    15 people found this answer helpful.

  2. Olaf Helper 47,436 Reputation points
    2023-01-30T06:55:15.0266667+00:00

    A know issue with Windows 11 + SQL Server is a misaligning disk sector size, see

    Troubleshoot errors related to system disk sector size greater than 4 KB

    1 person found this answer helpful.
    0 comments No comments

  3. Nrosario98 20 Reputation points
    2023-01-30T07:15:46.3633333+00:00

    Thank you for your reply. I will read the information to try to fix the problem. Best regards.

    0 comments No comments

  4. LiHongMSFT-4306 31,566 Reputation points
    2023-01-30T08:21:29.7833333+00:00

    Hi @Nrosario98

    As Olaf answered, Windows 11 uses different block sizes for disc alignment (32k) which aren't supported by SQL Server.

    Please follow by that link: Troubleshoot errors related to system disk sector size greater than 4 KB.

    Add the traceflag 1800 to the SQL Server startup parameter which might help.

    If still get error, please post the error logs. The location by default is: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log

    There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can find a Detail.txt file.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our **[Documentation](https://docs.microsoft.com/en-us/answers/support/email-notifications

    )** to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  5. Danny Hollis 75 Reputation points
    2023-03-03T13:08:36.8533333+00:00

    The installer hangs at SqlEngineConfigActioninstallconfignonrc_Cpu64

    It looks like there is a File Not Found Error, it continues to create MOF, then nothing.

    (01) 2023-03-03 23:25:25 Slp: PerfCounter munging INI tempate: 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqlctr.ini' -> 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\perf-MSSQLSERVERsqlctr.ini'
    (01) 2023-03-03 23:25:25 Slp: Sco: Attempting to replace string in file, source file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqlctr.ini', output file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\perf-MSSQLSERVERsqlctr.ini'
    (01) 2023-03-03 23:25:25 Slp: PerfCounter calling lodctr: 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\perf-MSSQLSERVERsqlctr.ini'
    (01) 2023-03-03 23:25:26 SQLEngine: --SqlEngineSetupPrivate: Entered RegisterUsageMetricsRole
    (01) 2023-03-03 23:25:26 SQLEngine: --SqlEngineSetupPrivate: Failed to set register with Software Usage Metrics: System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
       at System.Reflection.RuntimeAssembly.nLoadFile(String path, Evidence evidence)
       at System.Reflection.Assembly.LoadFile(String path)
       at Microsoft.SqlServer.Chainer.Infrastructure.SoftwareUsageMetrics.RegisterSUM(String productName, String roleName, Guid roleGuid)
       at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.RegisterUsageMetricsRole()
    (01) 2023-03-03 23:25:26 SQLEngine: --SqlEngineSetupPrivate: Done RegisterUsageMetricsRole
    (01) 2023-03-03 23:25:26 SQLEngine: : Checking Engine checkpoint 'XEventMofFile'
    (01) 2023-03-03 23:25:26 SQLEngine: : Checking Engine checkpoint 'XEventCompileMofFile'
    (01) 2023-03-03 23:25:26 SQLEngine: --XEventSetup: Compiling MOF file: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlpkg.mof
    (01) 2023-03-03 23:25:26 Slp: Sco: Attempting to install MOF file
    (01) 2023-03-03 23:25:26 Slp: Running: C:\Windows\system32\WBEM\mofcomp.exe "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlpkg.mof"
    (07) 2023-03-03 23:25:26 Slp: Microsoft (R) MOF Compiler Version 10.0.22621.1
    (07) 2023-03-03 23:25:26 Slp: Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
    (07) 2023-03-03 23:25:26 Slp: Parsing MOF file: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlpkg.mof
    (07) 2023-03-03 23:25:26 Slp: MOF file has been successfully parsed
    (15) 2023-03-03 23:25:26 Slp: Storing data in the repository...
    (15) 2023-03-03 23:33:05 Slp: Done!
    (01) 2023-03-03 23:33:05 SQLEngine: : Checking Engine checkpoint 'XEventMofFile_1'
    (01) 2023-03-03 23:33:05 SQLEngine: : Checking Engine checkpoint 'XEventCompileMofFile_1'
    (01) 2023-03-03 23:33:05 SQLEngine: --XEventSetup: Compiling MOF file: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlminpkg.mof
    (01) 2023-03-03 23:33:05 Slp: Sco: Attempting to install MOF file
    (01) 2023-03-03 23:33:05 Slp: Running: C:\Windows\system32\WBEM\mofcomp.exe "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlminpkg.mof"
    (06) 2023-03-03 23:33:05 Slp: Microsoft (R) MOF Compiler Version 10.0.22621.1
    (06) 2023-03-03 23:33:05 Slp: Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
    (06) 2023-03-03 23:33:05 Slp: Parsing MOF file: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\xesqlminpkg.mof
    (06) 2023-03-03 23:33:06 Slp: MOF file has been successfully parsed
    (12) 2023-03-03 23:33:06 Slp: Storing data in the repository...
    
    
    0 comments No comments

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.