Unable to install SQL Server 2019

Question

Hi all, I Have uninstalled Microsoft SQL Express 2019 on a Windows 10 O.S., and all the related installations.
After all I have tried to Install SQL Express, and SQL Shows the attached screen shot.
Maybe the configurationFile below is useful.

Thank You for your help.

;SQL Server 2019 Configuration File
[OPTIONS]

; By specifying this parameter and accepting Microsoft Python Open and Microsoft Python Server terms, you acknowledge that you have read and understood the terms of use.

IACCEPTPYTHONLICENSETERMS="False"

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.

ACTION="Install"

; Setup roles install SQL Server in a predetermined configuration.

ROLE="AllFeatures_WithDefaults"

; By specifying this parameter and accepting Microsoft R Open and Microsoft R Server terms, you acknowledge that you have read and understood the terms of use.

IACCEPTROPENLICENSETERMS="False"

; Specifies that SQL Server Setup should not display the privacy statement when ran from the command line.

SUPPRESSPRIVACYSTATEMENTNOTICE="False"

; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system.

ENU="True"

; Setup will not display any user interface.

QUIET="True"

; Setup will display progress only, without any user interaction.

QUIETSIMPLE="False"

; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block.

UIMODE="AutoAdvance"

; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.

UpdateEnabled="False"

; If this parameter is provided, then this computer will use Microsoft Update to check for updates.

USEMICROSOFTUPDATE="False"

; Specifies that SQL Server Setup should not display the paid edition notice when ran from the command line.

SUPPRESSPAIDEDITIONNOTICE="False"

; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services.

UpdateSource="MU"

; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install shared components.

FEATURES=SQLENGINE

; Displays the command line parameters usage.

HELP="False"

; Specifies that the detailed Setup log should be piped to the console.

INDICATEPROGRESS="True"

; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.

X86="False"

; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), or Analysis Services (AS).

INSTANCENAME="SQLEXPRESS"

; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed.

INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"

; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed.

INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"

; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance.

INSTANCEID="SQLEXPRESS"

; Account for SQL Server CEIP service: Domain\User or system account.

SQLTELSVCACCT="NT Service\SQLTELEMETRY$SQLEXPRESS"

; Startup type for the SQL Server CEIP service.

SQLTELSVCSTARTUPTYPE="Automatic"

; Specify the installation directory.

INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

; Agent account name

AGTSVCACCOUNT="NT AUTHORITY\SERVIZIO DI RETE"

; Auto-start service after installation.

AGTSVCSTARTUPTYPE="Disabled"

; CM brick TCP communication port

COMMFABRICPORT="0"

; How matrix will use private networks

COMMFABRICNETWORKLEVEL="0"

; How inter brick communication will be protected

COMMFABRICENCRYPTION="0"

; TCP port used by the CM brick

MATRIXCMBRICKCOMMPORT="0"

; Startup type for the SQL Server service.

SQLSVCSTARTUPTYPE="Automatic"

; Level to enable FILESTREAM feature at (0, 1, 2 or 3).

FILESTREAMLEVEL="0"

; The max degree of parallelism (MAXDOP) server configuration option.

SQLMAXDOP="0"

; Set to "1" to enable RANU for SQL Server Express.

ENABLERANU="True"

; Specifies a Windows collation or an SQL collation to use for the Database Engine.

SQLCOLLATION="Latin1_General_CI_AS"

; Account for SQL Server service: Domain\User or system account.

SQLSVCACCOUNT="NT Service\MSSQL$SQLEXPRESS"

; Set to "True" to enable instant file initialization for SQL Server service. If enabled, Setup will grant Perform Volume Maintenance Task privilege to the Database Engine Service SID. This may lead to information disclosure as it could allow deleted content to be accessed by an unauthorized principal.

SQLSVCINSTANTFILEINIT="True"

; Windows account(s) to provision as SQL Server system administrators.

SQLSYSADMINACCOUNTS="DESKTOP-9O969J2\Gabriel"

; The number of Database Engine TempDB files.

SQLTEMPDBFILECOUNT="1"

; Specifies the initial size of a Database Engine TempDB data file in MB.

SQLTEMPDBFILESIZE="8"

; Specifies the automatic growth increment of each Database Engine TempDB data file in MB.

SQLTEMPDBFILEGROWTH="64"

; Specifies the initial size of the Database Engine TempDB log file in MB.

SQLTEMPDBLOGFILESIZE="8"

; Specifies the automatic growth increment of the Database Engine TempDB log file in MB.

SQLTEMPDBLOGFILEGROWTH="64"

; Provision current user as a Database Engine system administrator for SQL Server 2019 Express.

ADDCURRENTUSERASSQLADMIN="True"

; Specify 0 to disable or 1 to enable the TCP/IP protocol.

TCPENABLED="0"

; Specify 0 to disable or 1 to enable the Named Pipes protocol.

NPENABLED="0"

; Startup type for Browser Service.

BROWSERSVCSTARTUPTYPE="Disabled"

; Use SQLMAXMEMORY to minimize the risk of the OS experiencing detrimental memory pressure.

SQLMAXMEMORY="2147483647"

; Use SQLMINMEMORY to reserve a minimum amount of memory available to the SQL Server Memory Manager.

SQLMINMEMORY="0"

Answer 1

Hi @Gabriel Mometti ,

When you encounter error, the most useful ones should be error log, it is loacted at: \Program Files\Microsoft SQL Server\MSSQLV.SQLEXPRESS\MSSQL\Log\ERRORLOG

This error may occur because previous installation of OLE DB of SQL Server was not removed properly, please try to unintall it agin:
https://learn.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?redirectedfrom=MSDN&view=sql-server-ver16&tabs=Windows10

If it does not work, you can refer to this thread, it is related to regedit, so please be very careful about it, back up the registry before you modify it

You need to go to error log to find the unexpected value (name: 'PackageName', value:), open the registry and find the key, rename the registry key GUID to something else

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Sorry, but I'm not able to find what driver to search for in the Error Log:

2022-07-20 17:31:24.85 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 19044: )

2022-07-20 17:31:24.85 Server UTC adjustment: 2:00
2022-07-20 17:31:24.85 Server (c) Microsoft Corporation.
2022-07-20 17:31:24.85 Server All rights reserved.
2022-07-20 17:31:24.85 Server Server process ID is 1664.
2022-07-20 17:31:24.85 Server System Manufacturer: 'HP', System Model: 'HP Pavilion Laptop 15-cc5xx'.
2022-07-20 17:31:24.85 Server Authentication mode is WINDOWS-ONLY.
2022-07-20 17:31:24.85 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2022-07-20 17:31:24.85 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2022-07-20 17:31:24.85 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
2022-07-20 17:31:24.85 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-T 4022
-T 4010
-T 1905
-T 3701
-T 8015
2022-07-20 17:31:24.86 Server SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-07-20 17:31:24.86 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-07-20 17:31:24.86 Server Detected 12173 MB of RAM. This is an informational message; no user action is required.
2022-07-20 17:31:24.86 Server Using conventional memory in the memory manager.
2022-07-20 17:31:24.86 Server Page exclusion bitmap is enabled.
2022-07-20 17:31:24.94 Server Buffer Pool: Allocating 2097152 bytes for 1297340 hashPages.
2022-07-20 17:31:24.96 Server Default collation: Latin1_General_CI_AS (Italiano 1040)
2022-07-20 17:31:25.03 Server Buffer pool extension is already disabled. No action is necessary.
2022-07-20 17:31:25.17 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2022-07-20 17:31:25.23 Server Query Store settings initialized with enabled = 1,
2022-07-20 17:31:25.24 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-07-20 17:31:25.25 Server This instance of SQL Server last reported using a process ID of 4892 at 20/07/2022 17:31:23 (local) 20/07/2022 15:31:23 (UTC). This is an informational message only; no user action is required.
2022-07-20 17:31:25.25 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-07-20 17:31:25.26 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.
2022-07-20 17:31:25.26 Server In-Memory OLTP initialized on lowend machine.
2022-07-20 17:31:25.29 Server [INFO] Created Extended Events session 'hkenginexesession'

2022-07-20 17:31:25.29 Server Database Instant File Initialization: abilitato. 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.
2022-07-20 17:31:25.30 Server Total Log Writer threads: 2. This is an informational message; no user action is required.
2022-07-20 17:31:25.31 Server Database Mirroring Transport is disabled in the endpoint configuration.
2022-07-20 17:31:25.32 Server clflushopt is selected for pmem flush operation.
2022-07-20 17:31:25.32 Server Software Usage Metrics is disabled.
2022-07-20 17:31:25.32 spid10s Warning ******************
2022-07-20 17:31:25.32 spid10s SQL Server started in single-user mode. This an informational message only. No user action is required.
2022-07-20 17:31:25.32 spid10s Starting up database 'master'.
2022-07-20 17:31:25.44 Server CLR version v4.0.30319 loaded.
2022-07-20 17:31:25.52 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
2022-07-20 17:31:25.55 spid10s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2022-07-20 17:31:25.55 spid10s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2022-07-20 17:31:25.58 spid10s SQL Trace ID 1 was started by login "sa".
2022-07-20 17:31:25.58 spid10s Server name is 'DESKTOP-9O969J2\SQLEXPRESS'. This is an informational message only. No user action is required.
2022-07-20 17:31:25.59 spid10s Starting up database 'msdb'.
2022-07-20 17:31:25.60 spid14s Starting up database 'mssqlsystemresource'.
2022-07-20 17:31:25.62 spid14s The resource database build version is 15.00.2000. This is an informational message only. No user action is required.
2022-07-20 17:31:25.67 spid14s Starting up database 'model'.
2022-07-20 17:31:25.73 spid14s Clearing tempdb database.
2022-07-20 17:31:25.76 spid17s A self-generated certificate was successfully loaded for encryption.
2022-07-20 17:31:25.76 spid17s Server local connection provider is ready to accept connection on [ \.\pipe\SQLLocal\SQLEXPRESS ].
2022-07-20 17:31:25.76 spid17s Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
2022-07-20 17:31:25.78 Server SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
2022-07-20 17:31:25.78 spid17s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2022-07-20 17:31:25.78 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/DESKTOP-9O969J2:SQLEXPRESS ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
2022-07-20 17:31:25.89 spid14s Starting up database 'tempdb'.
2022-07-20 17:31:26.07 spid10s Recovery is complete. This is an informational message only. No user action is required.
2022-07-20 17:31:27.35 spid10s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2022-07-20 17:31:27.35 spid10s .NET Framework runtime has been stopped.
2022-07-20 17:31:27.38 spid10s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Answer 3

There is no issue in your SQL Server errorlog, and I don't know why Yufei suggested that you should look there, because the error about the OLE DB provider has nothing to do with the Database Engine itself.

I don't think I've see this error before. I think the file we are most interested in is summary.txt, which you find in the folder listed in the screen shot. Also upload detail.txt, while you are at it. We may ask for more files later.