Forum Discussion
EoinByrne
Nov 14, 2023Copper Contributor
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
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