Skip to content

Latest commit

 

History

History
69 lines (49 loc) · 5.83 KB

installing-sql-server-native-client.md

File metadata and controls

69 lines (49 loc) · 5.83 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Installing
SQL Server Native Client 11.0 is installed with SQL Server 2016. Learn where components are installed. There is also a redistributable installation program.
markingmyname
maghan
07/15/2016
sql
native-client
reference
intro-installation
SQL Server Native Client, uninstalling
SQLNCLI, installing
SQLNCLI, uninstalling
Setup [SQL Server Native Client]
uninstalling SQL Server Native Client
data access [SQL Server Native Client], uninstalling SQL Server Native Client
installing SQL Server Native Client
SQL Server Native Client, installing
data access [SQL Server Native Client], installing SQL Server Native Client
removing SQL Server Native Client

Installing SQL Server Native Client

[!INCLUDE SQL Server]

Important

[!INCLUDEsnac-removed-oledb-and-odbc]

Microsoft [!INCLUDEssNoVersion] Native Client 11.0 is installed when you install [!INCLUDEsssql16-md].

There is no SQL Server 2016 Native Client. For more information, see SQL Server Native Client.

You can also get sqlncli.msi from the SQL Server 2012 Feature Pack web page. To download the most recent version of the SQL Server Native Client, go to Microsoft SQL Server 2012 Feature Pack. If a previous version of [!INCLUDEssNoVersion] Native Client earlier than SQL Server 2012 is also installed on the computer, [!INCLUDEssNoVersion] Native Client 11.0 will be installed side-by-side with the earlier version.

The [!INCLUDEssNoVersion] Native Client files (sqlncli11.dll, sqlnclir11.rll, and s11ch_sqlncli.chm) are installed to the following location:

%SYSTEMROOT%\system32\

Note

All appropriate registry settings for the [!INCLUDEssNoVersion] Native Client OLE DB provider and the [!INCLUDEssNoVersion] Native Client ODBC driver are made as part of the installation process.

The [!INCLUDEssNoVersion] Native Client header and library files (sqlncli.h and sqlncli11.lib) are installed in the following location:

%PROGRAMFILES%\Microsoft SQL Server\110\SDK

In addition to installing [!INCLUDEssNoVersion] Native Client as part of the [!INCLUDEssNoVersion] installation, there is also a redistributable installation program named sqlncli.msi, which can be found on the [!INCLUDEssNoVersion] installation disk in the following location: %CD%\Setup\.

You can distribute [!INCLUDEssNoVersion] Native Client through sqlncli.msi. You might have to install [!INCLUDEssNoVersion] Native Client when you deploy an application. One way to install multiple packages in what seems to the user to be a single installation is to use chainer and bootstrapper technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 and Adding Custom Prerequisites.

The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of [!INCLUDEssNoVersion] Native Client. If your application targets a platform other than the one it was developed on, you can download versions of sqlncli.msi for x64, Itanium, and x86 from the Microsoft Download Center.

When you invoke sqlncli.msi, only the client components are installed by default. The client components are files that support running an application that was developed using [!INCLUDEssNoVersion] Native Client. To also install the SDK components, specify ADDLOCAL=All on the command line. For example:

msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}

Silent Install

If you use the /passive, /qn, /qb, or /qr option with msiexec, you must also specify IACCEPTSQLNCLILICENSETERMS=YES, to explicitly indicate that you accept the terms of the end user license. This option must be specified in all capital letters.

Uninstalling SQL Server Native Client

Because applications such as [!INCLUDEssNoVersion] server and the [!INCLUDEssNoVersion] tools depend on [!INCLUDEssNoVersion] Native Client, it is important not to uninstall [!INCLUDEssNoVersion] Native Client until all dependent applications are uninstalled. To provider users with a warning that your application depends on [!INCLUDEssNoVersion] Native Client, use the APPGUID install option in your MSI, as follows:

msiexec /i sqlncli.msi APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}

The value passed to APPGUID is your specific product code. A product code must be created when using Microsoft Installer to bundle your application setup program.

See Also

Building Applications with SQL Server Native Client
Installation How-to Topics