question

bmac0002001 avatar image
bmac0002001 asked

How to clean up old SQL Server Express 2016 MSSQL directories left behind after upgrading to 2017

My security team have asked me to remove an old MSSQL directory on a Windows 2019 server because it showing vulnerabilities from a Tenable scan. I recently upgraded SQL Server Express 2016 to 2017 and the upgrade has left behind the old MSSQL directory eg C:\Program Files\Microsoft SQL Server\MSSQL13.VEEAMSQL2016. This directory is where the vulnerabilities are however I am unable to update the files in it because its not in use or doesn't contain any instances. In order to keep my security team happy whats the best way to go about removing this directory altogether? I have uninstalled all SQL server express 2016 components but this directory still remains. Can I just delete the directory? will anything break? I tested this on a test server and it wouldn't delete as it said files are still in use. I can see the log file still be written too but thats it. In addition to this, the following directory is showing vulnerabilities from the scans, C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap, can I remove this directory?

sql-server-express
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
bmac0002001 avatar image
bmac0002001 answered

Here is some example from the Tenable scan. The following KBs do not install as there is no detected SQL instances.


CriticalSecurity Updates for Microsoft SQL Server 2016 and 2017 x64 (August 2018)Microsoft has released a set of patches for x64 versions of SQL Server 2016 and 2017.http://www.nessus.org/u?02637930

http://www.nessus.org/u?b5296772

http://www.nessus.org/u?ded4707c

http://www.nessus.org/u?cc2f6328

http://www.nessus.org/u?4ab5e14c

http://www.nessus.org/u?0c6a7711

http://www.nessus.org/u?82d9f22e KB : 4293802

- C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\SQLServer2016\setup.exe has not been patched.

Remote version : 2015.131.5026.0

Should be : 2015.131.5081.1


MediumSecurity Updates for Microsoft SQL Server (January 2021)Microsoft has released the following security updates to address this issue:

-KB4583460

http://www.nessus.org/u?a2fa953d

http://www.nessus.org/u?362bf920

http://www.nessus.org/u?833fc41a

http://www.nessus.org/u?085ac1e7

http://www.nessus.org/u?85a48b10

http://www.nessus.org/u?f323c3fb

http://www.nessus.org/u?cdd8de3f

http://www.nessus.org/u?add91580

http://www.nessus.org/u?0dbdcec2 KB : 4583460

- C:\Program Files\Microsoft SQL Server\MSSQL13.VEEAMSQL2016\MSSQL\Binn\sqlservr.exe has not been patched.

Remote version : 2015.131.5026.0

Should be : 2015.131.5103.6

SQL Server Version : 13.0.5026.0 Express Edition

SQL Server Instance : VEEAMSQL2016


10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.