CODEWITHSUNDEEP
sql-serversql-server-2019gdr
hh_trj
hh_trj

Reputation: 1

Is it possible to uninstall or update the "Microsoft SQL Server 2019 Setup" program that is installed by SQL Server independently?

I'm looking for advice or recommendations on what should be done with the "Setup" program installed during the installation of SQL Server 2019 or 2022. After installation, can/should the Setup be removed or updated at any point?

Microsoft Defender Vulnerability Management is showing that one of our servers that has SQL Server 2019 has 14 vulnerabilities related to SQL Server 2019 being out of date. In Defender under "Inventory", it's saying we're using SQL Server 2019 version 15.0.4013.40. It lists the "evidence" of this version, or how it knows the version, as the registry key of the "Microsoft SQL Server 2019 Setup (English)" program, which is installed at C:\SQL2019.

If I run "SELECT @@VERSION" in SSMS, I can see that we're running the RTM-GDR version 15.0.2101.7. This appears to be the latest security release.

So, it's seeing an old version of the SQL Server Setup program and tying the vulnerabilities to that. This could be an issue with how Defender is accounting for SQL Server, but I want to make sure I'm not missing anything here.

The Microsoft SQL programs listed as being installed are:

When I try to uninstall the Microsoft SQL Server 2019 Setup (English) entry via Control Panel, I receive this error:

Warning 26003: Microsoft SQL Server 2019 Setup Support Files cannot be uninstalled because the following products are installed:

  • SQL Server 2019 Client Tools Extensions
  • SQL Server 2019 Client Tools Extensions
  • SQL Server 2019 XEvent
  • SQL Server 2019 XEvent
  • SQL Server 2019 Common Files
  • SQL Server 2019 Database Engine Shared
  • SQL Server 2019 Client Tools
  • Microsoft SQL Server 2019 RsFx Driver
  • SQL Server 2019 Database Engine Services

Upvotes: 0

Views: 10286

Answers (2)

mritunjaykumar07
mritunjaykumar07

Reputation: 1

To uninstall Microsoft SQL Server 2019 Setup Support Files when encountering an issue like Warning 26003, you can try the following steps:

1. Use Control Panel (Programs and Features):

  • Open Control Panel on your computer.
  • Go to "Programs" or "Programs and Features."
  • Find "Microsoft SQL Server 2019 Setup Support Files" in the list of installed programs.
  • Right-click on it and select "Uninstall" or "Remove."

2. Use Command Prompt (if Control Panel fails):

  • Open Command Prompt as an administrator.

  • Type wmic and press Enter.

  • Then, enter product get name and press Enter to get a list of installed programs.

  • Locate the entry for "Microsoft SQL Server 2019 Setup Support Files."

  • Type product where name="Microsoft SQL Server 2019 Setup Support Files" call uninstall and press Enter to uninstall.

3. Manual Removal (if both methods fail):

  • Navigate to the installation directory of SQL Server setup support files.
  • Typically, this is in C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap.
  • Look for an uninstall executable or batch file. It might be named something like uninstall.exe or uninstall.bat.
  • Run this executable as an administrator to uninstall the support files.

If you encounter any errors during uninstallation, note the specific error messages me.

Upvotes: -3

Binary
Binary

Reputation: 1

I was able to fix similar issue. I noticed Microsoft Defender Vulnerability Management displaying the SSMS client is outdated. However impacted machine had two different SQL verion. One of the version was installed in C:\SQL2022\ path. I wasn't able to uninstall and encounter the same behavior that you have reported. So I managed to install an app for the package from below link for SSMS 2022 version.

Downloaded the KB from Microsoft Update catalog and version got auto updated. However its best to know how to uninstall the conflicting version.

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/build-versions

Upvotes: 0

Related Questions