Help required with SQL Server

Question

Hi Team,

Could you please reply to below 2 points -

1. I have a requirement where I need to identify all windows machines where Microsoft SQL Server is installed (any version). To identify I have gone to control panel of each machine(inside uninstall and change a program) and look for below

• Microsoft SQL Server (any version)
• Microsoft SQL Server (any version) setup

does this looks correct or am I missing something

1. Once I have identified the SQL SERVER, I need to upgrade it to avoid any security vulnerability, on 1 machine I found SQL Server Native client 2012, do I need to consider it as SQL Server, if yes, how shall I proceed on upgrading it.

Thanks,

Salil

Answer 1

You can easy automate the lookup process using MS MAP = "Microsoft Assessment and Planning (MAP) toolkit"

See https://learn.microsoft.com/en-us/training/modules/sql-server-discovery-using-map/

Answer 2

SQL Server Native Client is not SQL Server. It is a client API DLL which includes both an OLE DB provider and an OBDC provider. It's old and outdated by now, and clients should be changed to use newer providers and drivers.

Looking through the Control Panel on each machine seems tedious. Not the least since there can be things with SQL Server in the name which is not SQL Server itself. SQL Server itself appears as Microsoft SQL Server nnnn (64-bit) or Microsoft SQL Server nnnn LocalDB.

Answer 3

Hi，Salil Singh

Looking at the versions of SQL Server that have been registered in the registry and installed correctly through the Control Panel is the right choice.

Microsoft SQL Server (any version) Microsoft SQL Server (any version) setup

Microsoft SQL Server setup is a tool used for installing, configuring, upgrading, or removing SQL Server instances and their related components.

The screenshot shown is an example of a SQL Server application：

You can use the sqlcmd -L command in CMD to list the SQL Server instances that are currently listening in the network environment.

You can also view the existing installed instances through SQL Server Configuration Manager.

Once I have identified the SQL SERVER, I need to upgrade it to avoid any security vulnerability, on 1 machine I found SQL Server Native client 2012, do I need to consider it as SQL Server, if yes, how shall I proceed on upgrading it.

The SQL Server Native Client 2012 is just a tool for linking up to databases. It's a standalone driver that doesn't have anything to do with your instances, so you don't need to worry about it.

Before upgrading your SQL Server version, please refer to the official documentation to get support.

Best Regards,

Mikey Qiao

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".