question

Fahrid95 avatar image
0 Votes"
Fahrid95 asked AmeliaGu-msft commented

microsoft sql server unsupported version detection

When I try to install Microsoft® SQL Server® 2014 Service Pack 3 (SP3) Express

it is creating the folder under C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn

instead C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn


Because of this I am getting the vulnerability microsoft sql server unsupported version detection

please suggest how to resolve this, earlier we used to install Microsoft® SQL Server® 2014 Service Pack 3 (SP3) Express

sql-server-generalwindows-server
· 1
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 @Fahrid95,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered OlafHelper-2800 commented

Because of this I am getting the vulnerability microsoft sql server unsupported version detection

Both folders are the same.
Which tool reports vulnerability? If a tool judge this just by folder name, then it's a very silly tool.

SQL Server 2014 with SP 3 is supported up to 07/09/2024, see
https://docs.microsoft.com/en-us/lifecycle/products/sql-server-2014



· 2
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.

My question is earlier when we install the tool it is not created express folder C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn but why it is creating the express folder now.


We are using Tenable tool to scan the vulnerability and do you any other information apart from the above one. If yes can you please share.

0 Votes 0 ·

That folder comes with the installation of SQL Server database engine, not when you only install tools.
The folder contains the instance name, and with default installation of Express Edition it is SQLEXPRESS.
So far is everything fine.

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @Fahrid95,
Agree with Olaf. The Binn folder in ProgramFiles\Microsoft SQL Server\<Instance_ID>.<Instance Name>\MSSQL\ is very important and cannot be deleted.
And if you need to configure scanning software, you can exclude files or directories from this doc (as applicable) from virus scanning.

Best Regards,
Amelia


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.