User Profile
EoinByrne
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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\. ..........................................................................................................................................................................................................
