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?

Accepted Answer

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 
```

Solution