SOLVED

[ISSUE] b20201 Inplace upgrade keeps failing Server vNext 0x8007042B-0x2000D w. SQL 2019 Express

MVP

 

vServer Next 20201 Desktop Experience

 

setupdiag 1.6.0.42 gives no further logfile.

 

 

non standard "config":

Azure AD Sync + SQL 2019 Express

Azure Update Management Client

Edge Dev

Windows Admin Center 2009

 

sources\rollback\setuperr.log

2020-11-19 02:20:08, Error SP CSetupPlatformOSSwitchCheckpoint::Rollback: Failed to read the rollback GUID from file: C:\$WINDOWS.~BT\Sources\Rollback\rollbackinfo.ini. Error: 0x00000002[gle=0x00000002]
2020-11-19 02:20:55, Error MOUPG CSetupHost::ExecuteDiagnosticAnalysis(1604): Result = 0x80004003
2020-11-19 02:20:57, Error [0x0803b6] MIG Can't retrieve group information for user NT SERVICE\MSSQL$MICROSOFT##WID. NetUserGetLocalGroups failed 0x000008AD
2020-11-19 02:20:57, Error [0x0803b6] MIG Can't retrieve group information for user NT SERVICE\SQLTELEMETRY$SQLEXPRESS_AZURE. NetUserGetLocalGroups failed 0x000008AD
2020-12-03 17:56:28, Error SP Failed to merge telemetry file: . hr = 0X80070057

 

Name Version
---- -------
Microsoft SQL Server 2019 T-SQL Language Service 15.0.20...
Microsoft OLE DB Driver for SQL Server 18.3.0.0
SQL Server Management Studio 15.0.18...
Microsoft Analysis Services OLE DB Provider 15.0.20...
Microsoft Visual C++ 2013 x86 Minimum Runtime - 12.0.40664 12.0.40664
Microsoft Help Viewer 2.3 2.3.28107
Microsoft Help Viewer 2.3 2.3.28107
SQL Server 2019 XEvent 15.0.20...
Microsoft SQL Server 2012 Command Line Utilities 11.4.70...
Microsoft Azure AD Connect 1.5.45.0
SQL Server 2019 Connection Info 15.0.20...
SQL Server 2019 DMF 15.0.20...
SQL Server Management Studio for Reporting Services 15.0.18...
Microsoft Visual C++ 2013 x64 Minimum Runtime - 12.0.40664 12.0.40664
Microsoft SQL Server 2019 RsFx Driver 15.0.20...
Microsoft VSS Writer for SQL Server 2019 15.0.20...
Microsoft Visual C++ 2019 X64 Minimum Runtime - 14.27.29112 14.27.2...
Microsoft Monitoring Agent 10.20.1...
Windows Admin Center 1.2.262...
Microsoft Edge 87.0.66...
SQL Server 2019 Database Engine Shared 15.0.20...
Browser for SQL Server 2019 15.0.20...
Microsoft SQL Server 2012 Native Client 11.4.74...
SQL Server 2019 Shared Management Objects Extensions 15.0.20...
SQL Server 2019 SQL Diagnostics 15.0.20...
Microsoft ODBC Driver 17 for SQL Server 17.6.1.1
Integration Services 15.0.20...
Microsoft Visual C++ 2019 X86 Minimum Runtime - 14.27.29112 14.27.2...
Microsoft Visual C++ 2019 X64 Additional Runtime - 14.27.29112 14.27.2...
SQL Server 2019 Shared Management Objects 15.0.20...
SQL Server 2019 Common Files 15.0.20...
Microsoft Visual C++ 2013 x64 Additional Runtime - 12.0.40664 12.0.40664
SQL Server 2019 Batch Parser 15.0.20...
Visual Studio 2017 Isolated Shell for SSMS 15.0.28...
SQL Server 2019 Database Engine Services 15.0.20...
Microsoft Visual C++ 2013 x86 Additional Runtime - 12.0.40664 12.0.40664
Microsoft Visual C++ 2019 X86 Additional Runtime - 14.27.29112 14.27.2...
Microsoft Visual Studio Tools for Applications 2017 x64 Hosting Support 15.0.27520
SQL Server Management Studio for Analysis Services 15.0.18...
Microsoft SQL Server 2019 Setup (English) 15.0.40...
SSMS Post Install Tasks 15.0.18...
Microsoft Visual Studio Tools for Applications 2017 x86 Hosting Support 15.0.27520
GDR 2070 for SQL Server 2019 (KB4517790) (64-bit) 15.0.20...
Microsoft SQL Server 2019 (64-bit)
Azure Data Studio 1.23.0
Microsoft Edge Update 1.3.139.59
Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.40664 12.0.40...
Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.27.29112 14.27.2...
Microsoft SQL Server Management Studio - 18.7 15.0.18...
Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.40664 12.0.40...
Microsoft Visual C++ 2015-2019 Redistributable (x86) - 14.27.29112 14.27.2...
Microsoft Visual Studio Tools for Applications 2017 15.0.27520
Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.327.840.0)
Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.327.794.0)
Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.327.728.0)
Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.327.670.0)
Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.327.607.0)
Servicing Update for SQL Server 2019 RTM GDR (KB4517790)

 

Error:

 

K_Wester-Ebbinghaus_0-1607014097874.png

 

seems this is a problem of setup not being able to migrated SQL local users?

 

What do you think? @Elden Christensen do we need to involve the setup & SQL Team? Thanks for mentions.

2 Replies
best response confirmed by Karl_Wester-Ebbinghaus (MVP)
Solution

This issue is fixed when upgrading to b20282

1 best response

Accepted Solutions
best response confirmed by Karl_Wester-Ebbinghaus (MVP)