Forum Discussion
SQL Server installation issues
Hello, I have issue installing SQL server as i need it for my classes but i keep getting this error message at the tail-end of installation. Can anyone help please? I have tried uninstal...
Balmukund-Lakhani
Microsoft
Microsoftthe message means that during the installation, SQL Service couldn't start. You should look at the SQL ERRORLOG file and share the content for further assistance.
Balmukund-Lakhani .Thanks for the reply. This is the error log:
2024-03-10 22:10:23.87 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: ) (Hypervisor)
2024-03-10 22:10:23.87 Server UTC adjustment: 0:00
2024-03-10 22:10:23.87 Server (c) Microsoft Corporation.
2024-03-10 22:10:23.87 Server All rights reserved.
2024-03-10 22:10:23.87 Server Server process ID is 8820.
2024-03-10 22:10:23.87 Server System Manufacturer: 'LENOVO', System Model: '82V6'.
2024-03-10 22:10:23.87 Server Authentication mode is WINDOWS-ONLY.
2024-03-10 22:10:23.87 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2024-03-10 22:10:23.88 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2024-03-10 22:10:23.88 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2024-03-10 22:10:23.88 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
-m "SqlSetup"
-T 4022
-T 4010
-T 1905
-T 3701
-T 8015
2024-03-10 22:10:23.88 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2024-03-10 22:10:23.88 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2024-03-10 22:10:23.88 Server Detected 3737 MB of RAM. This is an informational message; no user action is required.
2024-03-10 22:10:23.88 Server Using conventional memory in the memory manager.
2024-03-10 22:10:23.88 Server Page exclusion bitmap is enabled.
2024-03-10 22:10:23.90 Server Buffer Pool: Allocating 1048576 bytes for 593920 hashPages.
2024-03-10 22:10:23.92 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2024-03-10 22:10:23.96 Server Buffer pool extension is already disabled. No action is necessary.
2024-03-10 22:10:24.00 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2024-03-10 22:10:24.02 Server Query Store settings initialized with enabled = 1,
2024-03-10 22:10:24.03 Server The maximum number of dedicated administrator connections for this instance is '1'
2024-03-10 22:10:24.03 Server This instance of SQL Server last reported using a process ID of 11044 at 10/03/2024 22:10:15 (local) 10/03/2024 22:10:15 (UTC). This is an informational message only; no user action is required.
2024-03-10 22:10:24.03 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2024-03-10 22:10:24.04 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.
2024-03-10 22:10:24.05 Server In-Memory OLTP initialized on lowend machine.
2024-03-10 22:10:24.07 Server [INFO] Created Extended Events session 'hkenginexesession'
2024-03-10 22:10:24.07 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.
2024-03-10 22:10:24.07 Server Total Log Writer threads: 1. This is an informational message; no user action is required.
2024-03-10 22:10:24.07 Server Database Mirroring Transport is disabled in the endpoint configuration.
2024-03-10 22:10:24.07 Server clflushopt is selected for pmem flush operation.
2024-03-10 22:10:24.07 spid9s Warning ******************
2024-03-10 22:10:24.07 Server Software Usage Metrics is disabled.
2024-03-10 22:10:24.08 spid9s SQL Server started in single-user mode. This an informational message only. No user action is required.
2024-03-10 22:10:24.08 spid9s Starting up database 'master'.
2024-03-10 22:10:24.10 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.MSSQLSERVER\MSSQL\DATA\master.mdf.