Installing SQL Server Native Client 11.0

After installing the SQL engine, we need to load the last version of the client in order to access the local instance.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

Here's how to run the installation, in a command prompt window:

1. Install SQL Server Native Client 11.0 by running:

   C:\install\sqlncli.msi
   

2. Leave the default components selected for installation and click on Next until the end. As before, give the user account control permission to continue.

How it works...

We are forced to install this version of the client, as previous native clients are not able to connect to the LocalDB engine.

There's more...

Check successful outcome by clicking on Start | Administrative Tools | Data Sources (ODBC). Click on Continue if prompted, and in the ODBC Data Source Administrator window, select the Drivers tab. You should find among the last rows in this list both SQL Server and SQL Server Native Client 11.0.

Note

You can watch a screencast of this operation at:

• http://at5.us/Ch1V2