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

Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.