237 questions
Could you please try the recommended troubleshooting steps when disks have sector size greater than 4 KB? Please read here. It seems Scenario #4 is the problem you are facing.
SQL EXIT Code 2061893606
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 62%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWR%3C/text%3E%3C/svg%3E)
William R
0
Reputation points
Have purchased a new laptop for a bridge club which uses SQL as part of its scoring system
On previous laptops I have had no issues with SQL
However on the new laptop HP 17.3inch Laptop i7-cn3029TU I am unable to install SQL 2019 express or 2022 version.
I have claered all instances before retying.
Have read the windows work around and altered the registery but stll get same error
Error log is
2025-06-03 19:41:31.90 Server Microsoft SQL Server 2019 (RTM-GDR) (KB5046859) - 15.0.2130.3 (X64)
Oct 18 2024 15:25:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 26100: ) (Hypervisor)
2025-06-03 19:41:31.90 Server UTC adjustment: 12:00
2025-06-03 19:41:31.90 Server (c) Microsoft Corporation.
2025-06-03 19:41:31.90 Server All rights reserved.
2025-06-03 19:41:31.90 Server Server process ID is 19984.
2025-06-03 19:41:31.90 Server System Manufacturer: 'HP', System Model: 'HP Laptop 17-cn3xxx'.
2025-06-03 19:41:31.90 Server Authentication mode is WINDOWS-ONLY.
2025-06-03 19:41:31.90 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2025-06-03 19:41:31.90 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2025-06-03 19:41:31.90 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
2025-06-03 19:41:31.91 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-T 4022
-T 4010
-T 1905
-T 3701
-T 8015
2025-06-03 19:41:31.91 Server SQL Server detected 1 sockets with 6 cores per socket and 12 logical processors per socket, 12 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2025-06-03 19:41:31.91 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2025-06-03 19:41:31.91 Server Detected 16095 MB of RAM. This is an informational message; no user action is required.
2025-06-03 19:41:31.91 Server Using conventional memory in the memory manager.
2025-06-03 19:41:31.91 Server Page exclusion bitmap is enabled.
2025-06-03 19:41:32.04 Server Buffer Pool: Allocating 2097152 bytes for 1570407 hashPages.
2025-06-03 19:41:32.05 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2025-06-03 19:41:32.07 Server Buffer pool extension is already disabled. No action is necessary.
2025-06-03 19:41:32.08 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2025-06-03 19:41:32.09 Server Query Store settings initialized with enabled = 1,
2025-06-03 19:41:32.09 Server The maximum number of dedicated administrator connections for this instance is '1'
2025-06-03 19:41:32.09 Server This instance of SQL Server last reported using a process ID of 3984 at 3/06/2025 7:41:22 pm (local) 3/06/2025 7:41:22 am (UTC). This is an informational message only; no user action is required.
2025-06-03 19:41:32.09 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.
2025-06-03 19:41:32.10 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.
2025-06-03 19:41:32.10 Server In-Memory OLTP initialized on standard machine.
2025-06-03 19:41:32.11 Server [INFO] Created Extended Events session 'hkenginexesession'
2025-06-03 19:41:32.11 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.
2025-06-03 19:41:32.11 Server Total Log Writer threads: 2. This is an informational message; no user action is required.
2025-06-03 19:41:32.14 Server Database Mirroring Transport is disabled in the endpoint configuration.
2025-06-03 19:41:32.14 Server clwb is selected for pmem flush operation.
2025-06-03 19:41:32.14 Server Software Usage Metrics is disabled.
2025-06-03 19:41:32.14 spid10s Warning ******************
2025-06-03 19:41:32.14 spid10s SQL Server started in single-user mode. This an informational message only. No user action is required.
2025-06-03 19:41:32.14 spid10s Starting up database 'master'.
2025-06-03 19:41:32.15 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\DATA\master.mdf.
2025-06-03 19:41:32.21 Server CLR version v4.0.30319 loaded.
2025-06-03 19:41:32.25 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
Any help Most appreciated
Thanks William
SQL Server Database Engine
2 answers
Sort by: Most helpful
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator2025-06-04T01:27:27.5166667+00:00 -
William R 0 Reputation points
2025-06-04T01:55:53.42+00:00 Thanks Alberto
PhysicalBytes...... for Atomicity 4096
PhysicalBytes..... for performsnce 65536
I have tried the registery fix with *4095 but made no difference
Not sure what do to next
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
2025-06-04T02:17:06.29+00:00 As workaround, would you be willing to install SQL Server on Docker Desktop? You can connect using SSMS on your laptop to the SQL instance running on Docker.
-
William R 0 Reputation points
2025-06-04T02:49:14.9433333+00:00 I think at this time I need to keep things simple like the other laptops in the club running SQL. Having a different interface would be troublesome. I will keep that possibility for later.
Wonder if I set up a virtual hard drive and install to that might work?
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
2025-06-04T02:55:57.9266667+00:00 That may work. Mount it and assign a drive letter and try to install SQL Server on it.
-
William R 0 Reputation points
2025-06-04T22:54:16.6266667+00:00 Yes that worked on a VHD E:
Interestingly it did install some fileds on the C: drive
Now need to install the management studio and see what happens
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
2025-06-05T00:55:39.9033333+00:00 Yes. SQL Server always install some binaries on the system drive.
-
William R 0 Reputation points
2025-06-05T21:44:06.63+00:00 Installed management studio v21 to the C drive
When I run this I get the following when trying to connect
Wondering if it is anything to do with SQL being installed on a VHD
Any advice appreciated
TITLE: Connect to Server
Cannot connect to TBC2\SQLEXPRESS.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: SSL Provider, error: 0 - The certificate
chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -
2146893019)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-
events/mssqlserver--2146893019-database-engine-error
The certificate chain was issued by an authority that is not trusted
BUTTONS:
OK
-
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator2025-06-05T21:48:27.9433333+00:00 No, that has to do with your VHD drive. Check the option Trust Server Certificate - or change Mandatory to Optional in the dropdown above, and you will be fine.
Note: none of these choices would be advisable if you would be connecting to SQL Server over a network, least of all if you have sensitive data. For a connection to SQL Server on the same machine, there is no security issue.
Sign in to comment -
-
Olaf Helper 47,416 Reputation points2025-06-04T05:20:24.6733333+00:00 There have been 256 misaligned log IOs which required falling back to synchronous IO.
That's a known issue of Win 11 and some SSD disk, see