question

AkashNath-8235 avatar image
1 Vote"
AkashNath-8235 asked AlejandroPerezMollo-8133 commented

uninstalling sql server2019

Due to some connectivity issue with the sql server, I tried to uninstall and re-install sql server2019. But when i tried to uninstall it from settings>>apps>>apps and features>> Microsoft sql server 2019(64 bit)>> uninstall... it was unsuccessful and it threw an error. I have attached the snapshot of the error and below is the log summary . kindly help me to solve the issue.90886-error2-sql.png90961-error-sql.png




Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052294
Start time: 2021-04-24 18:31:33
End time: 2021-04-24 18:36:31
Requested action: Uninstall

Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for ComponentUpdate: Use the following information to resolve the error, and then, try to uninstall this feature again.


Machine Properties:
Machine name: DESKTOP-BDVL8SN
Machine processor count: 4
OS version: Microsoft Windows 10 Pro (10.0.19042)
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 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Developer Edition 15.0.2000.5 No Yes

Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation edition: Developer

User Input Settings:
ACTION: Uninstall
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210424_183132\ConfigurationFile.ini
ENU: true
FEATURES: SQLENGINE, BROWSER, WRITER
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: MSSQLSERVER
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false

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

Detailed results:
Feature: Database Engine Services
Status: Passed

Feature: SQL Browser
Status: Passed

Feature: SQL Writer
Status: Passed

Feature: Setup Support Files
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then, try to uninstall this feature again.
Component name: SQL Server Database Engine Services Shared Features
Component error code: 1722
Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210424_183132\sql_engine_core_shared_Cpu64_1.log
Error description: There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=sql_engine_core_shared.msi%40UninstallService.754C9258_CE8E_4420_9B81_7AD051B1479F%401722

Rules with failures or warnings:

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


sql-server-generalsql-server-reporting-services
error2-sql.png (56.7 KiB)
error-sql.png (32.5 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AkashNath-8235, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

sorry about that but i am not that of a technical person.. so i am not able to follow the steps you suggested. i'll get back to you once i figure it out.

0 Votes 0 ·

Hi @CarrinWu-MSFT 180690-windows-sql-programs.jpg180719-sql-programs.jpg180748-sql-software.jpg. I run into the same issue when trying to uninstall SQL Server 2019. When checking user removal instructions I found that I have several KEYS in the Registry. Follows screen shots of SQL Related KEYS in the Registry, SQL related APP and Features in Settings and SQL related folders in Windows\Program Files. I will appreciate if you could indicate which Registry Keys should be deleted, which APP programs should be deleted and which folders should be renamed/deleted
Thank you


0 Votes 0 ·
SSengupta-4080 avatar image
0 Votes"
SSengupta-4080 answered

You may try to uninstall manually:

http://www.sqlcoffee.com/Tips0026.htm


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @AkashNath-8235,

Welcome to Microsoft Q&A!

Before you uninstall your SQL Server, we recommend that you stop all SQL Server services before you uninstall SQL Server components. Active connections can prevent successful uninstallation. And then please follow below steps to uninstall SQL Server manually:

  1. Uninstall the existing SQL Server and all the components from the add remove program.

  2. Backup the registry.

  3. Delete the following keys using regedit:
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

  4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.

  5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.

  6. Rename all the SQL Server folders in the computer.

  7. Reboot the machine.

I have a similar issue before and solved by this solution, hope it will help you also.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

Hi @AkashNath-8235,

Please refer to below shotcreem to figure it out:
92392-1.png
92393-2.png
92366-3.png
92394-4.png
92367-5.png
92372-6.png
92373-7.png
92422-8.png
92451-9.png
92461-10.png
92384-11.png
92403-12.png
92404-13.png
92385-14.png
92432-15.png
Finally, restart your computer and reinstall SQL server.


13.png (12.9 KiB)
14.png (39.4 KiB)
15.png (47.4 KiB)
1.png (11.2 KiB)
2.png (24.7 KiB)
3.png (53.6 KiB)
4.png (37.3 KiB)
5.png (14.0 KiB)
6.png (55.0 KiB)
7.png (12.5 KiB)
8.png (13.1 KiB)
9.png (56.7 KiB)
10.png (11.8 KiB)
11.png (13.6 KiB)
12.png (65.4 KiB)
· 10
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thankyou for the screenshots.. it helped me follow the steps, but after i executed all the steps and tried to reinstall the SQL Server 2019, i got an error>> " unable to install SQL Server(setup.exe)." i have attached the error snap with this message.92516-installationerror-sql.png





0 Votes 0 ·

Hi, please check the error log(Path: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210426_172319\Detail.txt) and get more details. I think you might be not delete all the keys in register editor, you should delete all the components of SQL server, otherwise the installation will be not succeed. And you should use administrator permission when you install SQL Server (right click -> run as administrator).




0 Votes 0 ·

HI @CarrinWu-MSFT i followed all the steps again but still the issue was not resolved. Is there any other way to connect like a call or a video call to resolve this issue?

0 Votes 0 ·
Show more comments
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @AkashNath-8235,

(08) 2021-04-30 13:30:02 Slp: The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.

please refer to this solution for your issues:

I have faced the same problem and fixed it as below:
I downloadeded the portable (executable on any window based computer without installation) "Program Install and Uninstall troubleshooter" (a replacement of Windows Installer Cleanup Utility) from http://support.microsoft.com/kb/2438651 and executed the Fixit.exe. Have repeated the option named as "Fix problems with programs that can't be installed or uninstalled" to uninstalled the SQL Server 2008 registry entry(ies). After that, I installed the SQL Server 2008 which completed successfully.

Also, please close your Firewall service when you reinstall SQL Server. And then you could open Firewall service after you complete the installtion.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.