Check if SQL Server Client Is Installed

Question

How can one check to see if the SQL Server Client driver is installed? And is it also possible to determine the version?

Answer 1

Go to->Run->cmd->type regedit.exe and you see the registry under the ODBC folder:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\
    ODBC Drivers\SQL Server

I also find a complete answer about this issue, (based on MySQL, but basically is the same thing).

Edit later: according to your comment you have installed the 2005 version of SQL Server:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Native Client\CurrentVersion

Anyway I also show you how you can see the 2008 version to see the differences between the two versions.

For SQL Server 2008/R2:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\SQLNCLI10\CurrentVersion

For SQL Server 2012:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\SQLNCLI11\CurrentVersion 

Answer 2

This can be found by running odbcad32.exe.

From the Microsoft Support site:

To determine the version of SQL Server Native Client, use one of the following methods:

Method 1: On the system where you want to find the version of Native Client, start the ODBC Administrator (odbcad32.exe), and then check the Version column under the Drivers tab.

On 64-bit systems, also check odbcad64.exe.