Error installing Database Engine Services while Installing MS SQL Server 2022 Developer Edition

Question

Error installing Database Engine Services while Installing MS SQL Server 2022 Developer Edition

Gautam Kumar Behera 5

Steps taken:

Downloaded ISO file for MS SQL Server 2022 Developer Edition
Attempted to install but encountered error during Database Engine Service installation

Attached log files:

Detail.txt

Summary_gautam_pc_20230521_165542.txt

Device Information:

Installed 11th Gen Intel(R) Core(TM) i5-1135G7 processor with 16.0 GB RAM
Running Windows 11 Home Single Language, version 22H2 build 22621.1702

Anonymous

2023-05-22T05:44:37.5133333+00:00

Hi @Gautam Kumar Behera

You can refer to the official documentation to view the error log.

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver16
Anonymous

2023-05-23T08:31:48.6033333+00:00

Hi @Gautam Kumar Behera

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Anonymous

2023-05-26T08:29:48.44+00:00

Hi @Gautam Kumar Behera

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

1 answer

Your answer

Anonymous

2023-05-22T05:44:37.5133333+00:00

Hi @Gautam Kumar Behera

You can refer to the official documentation to view the error log.

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver16
Anonymous

2023-05-23T08:31:48.6033333+00:00

Hi @Gautam Kumar Behera

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Anonymous

2023-05-26T08:29:48.44+00:00

Hi @Gautam Kumar Behera

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

Erland Sommarskog 128K MVP Volunteer Moderator

I found this:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

This is a generic message which means that SQL Server did not start when Setup wanted to run configuration tasks.

You find the errorlog in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG. Note that this path applies to a default instance. If you installed a named instance, the part after MSSQL16 will be different.

If you see a message about 256 misaligned reads, you are running into a known issue where Windows 11 is reporting a sector size for some disk models that SQL Server cannot cope with. Microsoft has published an article with workarounds for this problem.

Gautam Kumar Behera 5

error log

2023-05-21 17:03:14.37 Server      Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
	Oct  8 2022 05:58:25 
	Copyright (C) 2022 Microsoft Corporation
	Developer Edition (64-bit) on Windows 10 Home Single Language 10.0 <X64> (Build 22621: )

2023-05-21 17:03:14.38 Server      UTC adjustment: 5:30
2023-05-21 17:03:14.38 Server      (c) Microsoft Corporation.
2023-05-21 17:03:14.38 Server      All rights reserved.
2023-05-21 17:03:14.38 Server      Server process ID is 9140.
2023-05-21 17:03:14.38 Server      System Manufacturer: 'LENOVO', System Model: '82L3'.
2023-05-21 17:03:14.38 Server      Authentication mode is WINDOWS-ONLY.
2023-05-21 17:03:14.38 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER2022\MSSQL\Log\ERRORLOG'.
2023-05-21 17:03:14.38 Server      The service account is 'NT Service\MSSQL$MSSQLSERVER2022'. This is an informational message; no user action is required.
2023-05-21 17:03:14.38 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER2022\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER2022\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER2022\MSSQL\DATA\mastlog.ldf
2023-05-21 17:03:14.38 Server      Command Line Startup Parameters:
	 -s "MSSQLSERVER2022"
	 -m "SqlSetup"
	 -Q
	 -q "Latin1_General_CI_AS"
	 -T 4022
	 -T 4010
	 -T 3659
	 -T 3610
	 -T 8015
2023-05-21 17:03:14.39 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-05-21 17:03:14.39 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-05-21 17:03:14.39 Server      Detected 16167 MB of RAM. This is an informational message; no user action is required.
2023-05-21 17:03:14.39 Server      Using conventional memory in the memory manager.
2023-05-21 17:03:14.39 Server      Detected pause instruction latency: 108 cycles.
2023-05-21 17:03:14.39 Server      Spin divider value used: 2
2023-05-21 17:03:14.39 Server      Page exclusion bitmap is enabled.
2023-05-21 17:03:14.47 Server      Buffer Pool: Allocating 4194304 bytes for 2101130 hashPages.
2023-05-21 17:03:14.48 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-05-21 17:03:14.49 Server      Buffer pool extension is already disabled. No action is necessary.
2023-05-21 17:03:14.51 Server      CPU vectorization level(s) detected:  SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2023-05-21 17:03:14.52 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-05-21 17:03:14.53 Server      Query Store settings initialized with enabled = 1, 
2023-05-21 17:03:14.53 Server      The maximum number of dedicated administrator connections for this instance is '1'
2023-05-21 17:03:14.53 Server      This instance of SQL Server last reported using a process ID of 14632 at 21-05-2023 17:03:13 (local) 21-05-2023 11:33:13 (UTC). This is an informational message only; no user action is required.
2023-05-21 17:03:14.54 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-05-21 17:03:14.55 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-05-21 17:03:14.55 Server      In-Memory OLTP initialized on standard machine.
2023-05-21 17:03:14.56 Server      [INFO] Created Extended Events session 'hkenginexesession'
2023-05-21 17:03:14.56 Server      Database Instant File Initialization: disabled. 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-05-21 17:03:14.57 Server      Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2023-05-21 17:03:14.59 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2023-05-21 17:03:14.59 Server      clwb is selected for pmem flush operation.
2023-05-21 17:03:14.59 spid27s     Warning ******************
2023-05-21 17:03:14.59 Server      Software Usage Metrics is disabled.
2023-05-21 17:03:14.59 spid27s     SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-05-21 17:03:14.59 spid27s     Starting up database 'master'.
2023-05-21 17:03:14.60 spid27s     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\MSSQL16.MSSQLSERVER2022\MSSQL\DATA\master.mdf.
2023-05-21 17:03:14.60 spid27s     Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2023-05-21 17:03:14.60 spid27s     Stack Signature for the dump is 0x0000000000000000
2023-05-21 17:03:14.60 spid27s     CDmpClient::ExecuteAllCallbacks started.
2023-05-21 17:03:14.60 spid27s     XE_DumpCallbacks is executing...
2023-05-21 17:03:14.61 spid27s     DumpCallbackSOS is executing...
2023-05-21 17:03:14.61 spid27s     DumpCallbackEE is executing...
2023-05-21 17:03:14.61 spid27s     DumpCallbackSE is executing...
2023-05-21 17:03:14.61 spid27s     DumpCallbackSEAM is executing...
2023-05-21 17:03:14.61 spid27s     DumpCallbackSSB is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackQE is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackFullText is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackSQLCLR is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackHk is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackRepl is executing...
2023-05-21 17:03:14.63 spid27s     DumpCallbackPolyBase is executing...
2023-05-21 17:03:14.63 spid27s     CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2023-05-21 17:03:14.65 Server      CLR version v4.0.30319 loaded.
2023-05-21 17:03:14.69 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2023-05-21 17:03:15.18 spid27s     External dump process return code 0x20000001.
External dump process returned no errors.

Gautam Kumar Behera 5 Reputation points

2023-05-22T07:06:45.6766667+00:00

ERRORLOG_compile.txt

it contains errorlog,errorlog.1,errorlog.2,errorlog.3

SQLDUMPER_ERRORLOG.log

kindly please look into it, guide me with a required solution
Erland Sommarskog 128K Reputation points MVP Volunteer Moderator

2023-05-22T21:06:47.28+00:00

Yes, you have that error about 256 misaligned reads that I referred to in my previous post. Please see the link in this post for on how to proceed.

Share via

Error installing Database Engine Services while Installing MS SQL Server 2022 Developer Edition

1 answer

Your answer