registry - 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_MACHINESOFTWAREODBCODBCINST.INI
    ODBC DriversSQL 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_MACHINESOFTWAREMicrosoft
Microsoft SQL Native ClientCurrentVersion

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_MACHINESOFTWAREMicrosoft
Microsoft SQL ServerSQLNCLI10CurrentVersion

For SQL Server 2012:

HKEY_LOCAL_MACHINESOFTWAREMicrosoft
Microsoft SQL ServerSQLNCLI11CurrentVersion