Forum Discussion

EoinByrne's avatar
EoinByrne
Copper Contributor
Nov 14, 2023

Unable to install SQL Server 2019

Im getting the following error message with installing SQL Express Edition on Windows 11

 

I see 3log files after trying to install

 

Log File 1 

................................................................................................................................................................................................................

2023-11-14 08:08:48.62 Server      Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 
Sep 24 2019 13:48:23 
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: )
 
2023-11-14 08:08:48.63 Server      UTC adjustment: 0:00
2023-11-14 08:08:48.63 Server      (c) Microsoft Corporation.
2023-11-14 08:08:48.63 Server      All rights reserved.
2023-11-14 08:08:48.63 Server      Server process ID is 4940.
2023-11-14 08:08:48.63 Server      System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: '950XDB/951XDB/950XDY'.
2023-11-14 08:08:48.63 Server      Authentication mode is WINDOWS-ONLY.
2023-11-14 08:08:48.63 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2023-11-14 08:08:48.63 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2023-11-14 08:08:48.63 Server      Registry startup parameters: 
-d C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2023-11-14 08:08:48.63 Server      Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "Latin1_General_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2023-11-14 08:08:48.63 Server      SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2023-11-14 08:08:48.63 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-11-14 08:08:48.63 Server      Detected 16057 MB of RAM. This is an informational message; no user action is required.
2023-11-14 08:08:48.63 Server      Using conventional memory in the memory manager.
2023-11-14 08:08:48.63 Server      Page exclusion bitmap is enabled.
2023-11-14 08:08:48.72 Server      Buffer Pool: Allocating 2097152 bytes for 1766390 hashPages.
2023-11-14 08:08:48.73 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-11-14 08:08:48.75 Server      Buffer pool extension is already disabled. No action is necessary.
2023-11-14 08:08:48.77 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-11-14 08:08:48.78 Server      Query Store settings initialized with enabled = 1, 
2023-11-14 08:08:48.78 Server      The maximum number of dedicated administrator connections for this instance is '1'
2023-11-14 08:08:48.78 Server      This instance of SQL Server last reported using a process ID of 11960 at 14/11/2023 08:08:46 (local) 14/11/2023 08:08:46 (UTC). This is an informational message only; no user action is required.
2023-11-14 08:08:48.78 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2023-11-14 08:08:48.78 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2023-11-14 08:08:48.79 Server      In-Memory OLTP initialized on standard machine.
2023-11-14 08:08:48.80 Server      [INFO] Created Extended Events session 'hkenginexesession'
 
2023-11-14 08:08:48.80 Server      Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2023-11-14 08:08:48.81 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2023-11-14 08:08:48.82 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2023-11-14 08:08:48.82 Server      clwb is selected for pmem flush operation.
2023-11-14 08:08:48.82 Server      Software Usage Metrics is disabled.
2023-11-14 08:08:48.82 spid10s     Warning ******************
2023-11-14 08:08:48.82 spid10s     SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-11-14 08:08:48.82 spid10s     Starting up database 'master'.
2023-11-14 08:08:48.83 spid10s     There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2023-11-14 08:08:48.91 Server      CLR version v4.0.30319 loaded.
2023-11-14 08:08:48.94 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
.........................................................................................................................................................................................................
Log File 2 
2023-11-14 08:08:45.93 Server      Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 
Sep 24 2019 13:48:23 
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: )
 
2023-11-14 08:08:45.94 Server      UTC adjustment: 0:00
2023-11-14 08:08:45.94 Server      (c) Microsoft Corporation.
2023-11-14 08:08:45.94 Server      All rights reserved.
2023-11-14 08:08:45.94 Server      Server process ID is 11960.
2023-11-14 08:08:45.94 Server      System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: '950XDB/951XDB/950XDY'.
2023-11-14 08:08:45.94 Server      Authentication mode is WINDOWS-ONLY.
2023-11-14 08:08:45.94 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2023-11-14 08:08:45.94 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2023-11-14 08:08:45.94 Server      Registry startup parameters: 
-d C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2023-11-14 08:08:45.94 Server      Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "Latin1_General_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2023-11-14 08:08:45.94 Server      SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2023-11-14 08:08:45.94 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-11-14 08:08:45.94 Server      Detected 16057 MB of RAM. This is an informational message; no user action is required.
2023-11-14 08:08:45.94 Server      Using conventional memory in the memory manager.
2023-11-14 08:08:45.94 Server      Page exclusion bitmap is enabled.
2023-11-14 08:08:46.06 Server      Buffer Pool: Allocating 2097152 bytes for 1768208 hashPages.
2023-11-14 08:08:46.07 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-11-14 08:08:46.09 Server      Buffer pool extension is already disabled. No action is necessary.
2023-11-14 08:08:46.11 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-11-14 08:08:46.11 Server      Query Store settings initialized with enabled = 1, 
2023-11-14 08:08:46.12 Server      The maximum number of dedicated administrator connections for this instance is '1'
2023-11-14 08:08:46.12 Server      This instance of SQL Server last reported using a process ID of 1136 at 14/11/2023 08:08:41 (local) 14/11/2023 08:08:41 (UTC). This is an informational message only; no user action is required.
2023-11-14 08:08:46.12 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2023-11-14 08:08:46.12 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2023-11-14 08:08:46.13 Server      In-Memory OLTP initialized on standard machine.
2023-11-14 08:08:46.13 Server      [INFO] Created Extended Events session 'hkenginexesession'
 
2023-11-14 08:08:46.13 Server      Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2023-11-14 08:08:46.15 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2023-11-14 08:08:46.16 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2023-11-14 08:08:46.16 Server      clwb is selected for pmem flush operation.
2023-11-14 08:08:46.16 Server      Software Usage Metrics is disabled.
2023-11-14 08:08:46.16 spid9s      Warning ******************
2023-11-14 08:08:46.16 spid9s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-11-14 08:08:46.17 spid9s      Starting up database 'master'.
2023-11-14 08:08:46.17 spid9s      There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2023-11-14 08:08:46.26 Server      CLR version v4.0.30319 loaded.
2023-11-14 08:08:46.29 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
 
................................................................................................................................................................................................................
 
Log file 3
2023-11-14 08:08:41.62 Server      Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 
Sep 24 2019 13:48:23 
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: )
 
2023-11-14 08:08:41.64 Server      UTC adjustment: 0:00
2023-11-14 08:08:41.64 Server      (c) Microsoft Corporation.
2023-11-14 08:08:41.64 Server      All rights reserved.
2023-11-14 08:08:41.64 Server      Server process ID is 1136.
2023-11-14 08:08:41.64 Server      System Manufacturer: 'SAMSUNG ELECTRONICS CO., LTD.', System Model: '950XDB/951XDB/950XDY'.
2023-11-14 08:08:41.64 Server      Authentication mode is WINDOWS-ONLY.
2023-11-14 08:08:41.64 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2023-11-14 08:08:41.64 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2023-11-14 08:08:41.64 Server      Registry startup parameters: 
-d C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2023-11-14 08:08:41.64 Server      Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "Latin1_General_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2023-11-14 08:08:41.65 Server      SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2023-11-14 08:08:41.66 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-11-14 08:08:41.66 Server      Detected 16057 MB of RAM. This is an informational message; no user action is required.
2023-11-14 08:08:41.66 Server      Using conventional memory in the memory manager.
2023-11-14 08:08:41.66 Server      Page exclusion bitmap is enabled.
2023-11-14 08:08:41.72 Server      Buffer Pool: Allocating 2097152 bytes for 1764925 hashPages.
2023-11-14 08:08:41.73 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-11-14 08:08:41.76 Server      Buffer pool extension is already disabled. No action is necessary.
2023-11-14 08:08:41.86 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-11-14 08:08:41.88 Server      Query Store settings initialized with enabled = 1, 
2023-11-14 08:08:41.90 Server      The maximum number of dedicated administrator connections for this instance is '1'
2023-11-14 08:08:41.91 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2023-11-14 08:08:41.91 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2023-11-14 08:08:41.92 Server      In-Memory OLTP initialized on standard machine.
2023-11-14 08:08:41.93 Server      [INFO] Created Extended Events session 'hkenginexesession'
 
2023-11-14 08:08:41.93 Server      Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2023-11-14 08:08:41.93 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2023-11-14 08:08:41.95 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2023-11-14 08:08:41.95 Server      clwb is selected for pmem flush operation.
2023-11-14 08:08:41.95 Server      Software Usage Metrics is disabled.
2023-11-14 08:08:41.95 spid8s      Warning ******************
2023-11-14 08:08:41.95 spid8s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-11-14 08:08:41.95 spid8s      Starting up database 'master'.
2023-11-14 08:08:41.96 spid8s      There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2023-11-14 08:08:42.18 Server      CLR version v4.0.30319 loaded.
2023-11-14 08:08:42.22 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
 
..........................................................................................................................................................................................................
 
 
 
 


 

No RepliesBe the first to reply

Resources