summary.txt after rebuild the system database.

bestrongself 1 Reputation point
2025-03-05T23:49:04.68+00:00

I ran the following command to rebuild the system database

X:\Backups\2019>setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myusername

Microsoft (R) SQL Server 2019 15.00.2000.05

Copyright (c) 2019 Microsoft. All rights reserved.

SQL Server 2019 transmits information about your installation experience, as well as other usage and performance data, to Microsoft to help improve the product. To learn more about SQL Server 2019 data processing and privacy controls, please see the Privacy Statement.

Here is summary.txt

Overall summary:

Final result: Failed: see details below

Exit code (Decimal): -2061893614

Start time: 2025-03-05 17:25:12

End time: 2025-03-05 17:25:30

Requested action: RebuildDatabase

Setup completed with required actions for features.

Troubleshooting information for those features:

Next step for SQLEngine: Use the following information to resolve the error, and then try the setup process again.

Machine Properties:

Machine name: DWPYCDB01

Machine processor count: 4

OS version: Microsoft Windows Server 2019 Standard (10.0.17763)

OS service pack:

OS region: United States

OS language: English (United States)

OS architecture: x64

Process architecture: 64 Bit

OS clustered: No

Product features discovered:

Product Instance Instance ID Feature Language Edition Version Clustered Configured

SQL Server 2019 SIS_MDX MSAS15.SIS_MDX Analysis Services 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 SIS_TAB MSAS15.SIS_TAB Analysis Services 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Machine Learning Services and Language Extensions 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER AdvancedAnalytics\sql_inst_mpy 1033 Enterprise Edition 15.0.4415.2 No Yes

SQL Server 2019 Integration Services 1033 Enterprise Edition 15.0.4415.2 No Yes

Package properties:

Description: Microsoft SQL Server 2019

ProductName: SQL Server 2019

Type: RTM

Version: 15

SPLevel: 0

Installation location: X:\Backups\2019\x64\setup\

Installation edition:

User Input Settings:

ACTION: RebuildDatabase

CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20250305_172512\ConfigurationFile.ini

ENU: true

HELP: false

IACCEPTPYTHONLICENSETERMS: false

IACCEPTROPENLICENSETERMS: false

IACKNOWLEDGEENTCALLIMITS: false

INDICATEPROGRESS: false

INSTANCENAME: MSSQLSERVER

MRCACHEDIRECTORY:

QUIET: true

QUIETSIMPLE: false

SAPWD: <empty>

SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

SQLMAXDOP: 4

SQLMAXMEMORY: 2147483647

SQLMINMEMORY: 0

SQLSYSADMINACCOUNTS: domain\myusername

SQLTEMPDBDIR: <empty>

SQLTEMPDBFILECOUNT: 4

SQLTEMPDBFILEGROWTH: 64

SQLTEMPDBFILESIZE: 8

SQLTEMPDBLOGDIR: <empty>

SQLTEMPDBLOGFILEGROWTH: 64

SQLTEMPDBLOGFILESIZE: 8

SUPPRESSPAIDEDITIONNOTICE: false

SUPPRESSPRIVACYSTATEMENTNOTICE: false

UIMODE: Normal

USESQLRECOMMENDEDMEMORYLIMITS: false

X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20250305_172512\ConfigurationFile.ini

Detailed results:

Feature: Database Engine Services

Status: Failed

Reason for failure: An error occurred during the setup process of the feature.

Next Step: Use the following information to resolve the error, and then try the setup process again.

Component name: SQL Server Database Engine Services Instance Features

Component error code: 0x851A0012

Error description: Missing sa account password. The sa account password is required for SQL Authentication Mode.

Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4415.2&EvtType=0x8E91D6AA%400x97A656BB%401306%4018&EvtType=0x8E91D6AA%400x97A656BB%401306%4018

Feature: SQL Browser

Status: Passed

Feature: SQL Writer

Status: Passed

Rules with failures or warnings:

Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20250305_172512\SystemConfigurationCheck_Report.htm

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.