Microsoft sql server 2012 native client windows server 2012

Internet Explorer was retired on June 15, 2022

IE 11 is no longer accessible. You can reload Internet Explorer sites with IE mode in Microsoft Edge.

Internet Explorer is changing to Edge.

Latest servicing update available for the Microsoft® SQL Server® 2012 Native Client

Important! Selecting a language below will dynamically change the complete page content to that language.

  • File Name:

    ENU\x64\sqlncli.msi

    ENU\x86\sqlncli.msi

    The Microsoft® SQL Server® 2012 Native Client is available as part of Microsoft® SQL Server® 2012 Feature Pack, which is updated at each SQL Server 2012 Service Pack.

    This download is the latest cumulative servicing (QFE) update made to the most recent 2012 Feature Pack release of the SQL Server® 2012 Native Client. Please reference SQL Server 2012 Native Client support Knowledge Base articles for servicing update details.

    Note that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client. The SQL Server 2012 Native Client (v11, e.g. sqlncli11.dll), can continue to be utilized by SQL Server 2014 and later versions.

  • Supported Operating Systems

    Windows 10, Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

    Note:
    This site currently contains only the English servicing release. Please check back soon for other languages.

С 15.06.2022 г. IE 11 не поддерживается

IE11 станет недоступным с 14.02.2023. Сайты, созданные для IE, можно перезапустить в режиме IE в Microsoft Edge.

Internet Explorer превращается в Edge.

Последнее служебное обновление, доступное для Microsoft® SQL Server® 2012 Native Client

Важно! Если выбрать язык ниже, содержимое страницы динамически отобразится на выбранном языке.

  • Date Published:

    16.11.2017

    File Name:

    RUS\x64\sqlncli.msi

    RUS\x86\sqlncli.msi

    Microsoft® SQL Server® 2012 Native Client входит в состав пакета дополнительных компонентов Microsoft® SQL Server® 2012, который обновляется с выходом каждого пакета обновления SQL Server 2012.

    Этот скачиваемый файл содержит последнее накопительное служебное обновление (исправление QFE) последнего выпуска пакета дополнительных компонентов 2012 для SQL Server® 2012 Native Client. Подробности см. в статье базы знаний.

  • Поддерживаемые операционные системы

    Windows 10, Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

    Примечание.Убедитесь, что выбрали для скачивания язык и архитектуру, подходящие для вашей системы.

RRS feed

  • Remove From My Forums
  • Question

  • I tried to install the SQL Native Client 2012 on a Windows 2012 R2 box and it failed with a message saying that it is not supported on that OS.  Is there a version of SQL Native Client for Windows 2012 R2?  If not, is there a work around?

    Thanks

    Bert

    • Changed type
      Bert Penney
      Thursday, January 9, 2014 2:38 AM

Answers

    • Marked as answer by
      Fanny Liu
      Thursday, January 16, 2014 2:43 AM

All replies

  • Well, I haven’t received much feedback, but I have discovered 2 things:

    1. Installation of SCSM on W2K12R2 is supported (http://technet.microsoft.com/en-us/library/dn281935.aspx) — which implies that there is a version of the SQL Native Client that does
      work on W2K12R2, since it is required to install SCSM 2K12R2.
    2. I am not the first to discover this problem.  As commenter Jeziel Brizolla points out, the client referred to in this blog (http://blogs.technet.com/b/kevinholman/archive/2013/10/18/service-manager-2012-r2-quickstart-deployment-guide.aspx)
      does not work — and it is the same client I am trying to install.  Unfortunately, Jeziel didn’t get a response so I don’t know what the solution is.

    Does anyone know if there is another version of the client available somewhere?  I haven’t been able to find it on TechNet and the MSDN one I have is, as far as I know, the latest.

    Bert

    • Proposed as answer by
      Fanny Liu
      Friday, January 10, 2014 9:05 AM
    • Unproposed as answer by
      Fanny Liu
      Friday, January 10, 2014 9:05 AM

    • Marked as answer by
      Fanny Liu
      Thursday, January 16, 2014 2:43 AM
  • Thanks, Fanny.  I was able to get it installed yesterday.

    Bert

  • Hello ,

    SQL Native Client 2012 is possibly unsupported on Windows Server 2012 Core Edition ( you must have the full .Net Framework ) .

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

  • I’ve downloaded the sqlncli.msi from the feature pack link you provided, but it still wont install and gives the same error. The Windows 2012 R2 server has all the latest updates applied as of today.

  • I am experiencing same results as Willmgo. The WS2012 R2 instance is fresh and fully patched/updated.

  • More specifically, as others have pointed out the 32bit drivers from SP1 will not install on Windows 2012 R2.

    As David said in order to get the 32bit ODBC driver for Native Client 11 you must, as stupid as it may sound, install the 64bit driver.

    Regards,

    Paul Zahra

    • Edited by
      devastated
      Friday, November 7, 2014 1:02 PM

  • YES, THIS WORKS, USE AMD64 FOR 2012R2, ALL THE FILE NAME IS SAME SQLNCLI.EXE, SHOULD CHOICE BEFORE DOWNLOAD

SQL Server 2012 Native Client (SSNAC) is a new feature of SQL Server that allows you to run SQL Server 2012 applications on devices that do not have a full SQL Server installation. SSNAC is available in both Express and Standard editions of SQL Server 2012.

SSNAC is a great option for users who want to run a small number of SQL Server 2012 applications on their devices without having to install the full SQL Server 2012 software. SSNAC also offers a number of benefits over using traditional remote connections, such as reduced network traffic and improved performance.

To install SSNAC, you first need to download and install the SQL Server 2012 Native Client Express or Standard edition. Once the Express or Standard edition of SQL Server 2012 is installed, you can install the SSNAC feature by following these steps:

1. In the SQL Server 2012 Express or Standard edition, open the Management Studio.

2. In the Management Studio, click the Tools menu, and then click SSNAC.

3. In the SSNAC window, click the Add button.

4. In the Add SSNAC Server dialog box, enter the server name or IP address of the SQL Server 2012 Express or Standard edition that you want to use for SSNAC.

5. In the Port Number field, enter the port number that the SQL Server 2012 Express or Standard edition is using for remote connections.

6. In the Authentication Type field, select the type of authentication that you want to use for the connection.

7. In the User Name and Password fields, enter the user name and password for the SQL Server 2012 Express or Standard edition.

8. Click the OK button.

9. In the SSNAC window, click the Start button.

10. In the SSNAC window, click the Stop button to stop the SSNAC server.

11. In the SSNAC window, click the Close button to close the SSNAC window.

12. In the Management Studio, click the Servers tab, and then click the SSNAC server that you just created.

13. In the SSNAC window, click the Connect button to connect to the SSNAC server.

14. In the Connect to Server dialog box, enter the user name and password that you used in step 7.

15. In the Results pane, you should see a list of the SQL Server

Table Of Contents Show

  • How to Silently Install Microsoft SQL Server 2012 Native Client
  • Additional Configurations
  • Create an Installation Log File
  • Uninstalling Microsoft SQL Server 2012 Native Client Quietly
  • What is the procedure for launching SQL Server Native Client?
  • What is the purpose of the Microsoft SQL Server 2012 Native Client?
  • How do I start SQL Server 2012 after it has been installed?
  • What happened to my SQL Server Native Client?

Important: Choosing a language from the list below will dynamically change the entire page content to that language.

The most recent servicing update for the Microsoft® SQL Server® 2012 Native Client is now available.

Details

  • Note: This download contains multiple files; after clicking the «Download» button, you will be prompted to select the files you require.

    ENU\x64\sqlncli.msi

    ENU\x86\sqlncli.msi

    • The Microsoft® SQL Server® 2012 Native Client is included in the Microsoft® SQL Server® 2012 Feature Pack and is updated with each SQL Server 2012 Service Pack.

      This download contains the most recent cumulative servicing (QFE) update made to the most recent 2012 Feature Pack release of the SQL Server® 2012 Native Client. For more information on servicing updates, please see the SQL Server 2012 Native Client support Knowledge Base articles.

      It should be noted that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client.SQL Server 2014 and later versions can continue to use sqlncli11.dll.

System Requirements

  • Supported Operating System

    Windows 10, Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, and Windows Server 2012 R2.

    Can I simply download the SQL server native client installation file and replace the existing native client?

    Or do I need to uninstall the existing native client and reinstall it?

    No, you do not need to uninstall any previous native clients.

    According to the official document Installing SQL Server Native Client

    If a previous version of SQL Server Native Client is already installed on the computer, SQL Server Native Client 11.0 will be installed alongside it.

    Please keep in mind that after downloading the SQL Server 2012 native client, no future SQL Server versions’ native clients will be available for download separately, and the SQL Server 2012 native client can only be used with SQL Server 2012 and later versions.

    It should be noted that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client.SQL Server 2014 and later versions can continue to use sqlncli11.dll.

    This article will serve as an informative guide and provide you with a clear understanding of how to perform a silent installation of the Microsoft SQL Server 2012 Native Client from the command line using the MSI installer.

    How to Silently Install Microsoft SQL Server 2012 Native Client

    Silent Install (MSI) of Microsoft SQL Server 2012 Native Client on 32-bit Systems

    1. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=50402
    2. Select the ENU\x86\sqlncli.msi
    3. Download sqlncli.msi to a folder created at (C:Downloads).
    4. Right-click on Command Prompt and select Run as Administrator to open an Elevated Command Prompt.
    5. Navigate to the C:\Downloads folder
    6. Enter the following command: MsiExec.exe /i sqlncli.msi IACCEPTSQLNCLILICENSETERMS=YES /qn
    7. Press Enter

    After a few moments, you should see Microsoft SQL Server 2012 Native Client entries in both the Installation Directory and the Control Panel’s Programs and Features.

    Software Title:Microsoft SQL Server 2012 Native ClientVendor:Microsoft CorporationVersion:11.0.7001.0Architecture:32-bitInstaller Type:MSISilent Install Switch:MsiExec.exe /i sqlncli.msi IACCEPTSQLNCLILICENSETERMS=YES /qnSilent Uninstall Switch:MsiExec.exe /x {CC4970BA-B7DD-46E9-8941-192D6246DB5F} /qnRepair Command:MsiExec.exe /fa {CC4970BA-B7DD-46E9-8941-192D6246DB5F} /qnDownload Link:https://www.microsoft.com/en-us/download/details.aspx?id=50402PowerShell Script:https://silentinstall


    Silent Install (MSI) of Microsoft SQL Server 2012 Native Client on 64-bit Systems

    1. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=50402
    2. Select the ENU\x64\sqlncli.msi
    3. Download sqlncli.msi to a folder created at (C:Downloads).
    4. Right-click on Command Prompt and select Run as Administrator to open an Elevated Command Prompt.
    5. Navigate to the C:\Downloads folder
    6. Enter the following command: MsiExec.exe /i sqlncli.msi IACCEPTSQLNCLILICENSETERMS=YES /qn
    7. Press Enter

    After a few moments, you should see Microsoft SQL Server 2012 Native Client entries in both the Installation Directory and the Control Panel’s Programs and Features.

    Microsoft SQL Server Express 2019 S…

    Please enable JavaScript

    Silent Installation of Microsoft SQL Server 2019 Express (How-To Guide)Software Title:Microsoft SQL Server 2012 Native ClientVendor:Microsoft CorporationVersion:11.0.7001.0Architecture:64-bitInstaller Type:MSISilent Install Switch:MsiExec.exe /i sqlncli.msi IACCEPTSQLNCLILICENSETERMS=YES /qnSilent Uninstall Switch:MsiExec.exe /x {B9274744-8BAE-4874-8E59-2610919CD419} /qnRepair Command:MsiExec.exe /fa {B9274744-8BAE-4874-8E59-2610919CD419} /qnDownload Link:https://www.microsoft.com/en-us/download/details.aspx?id=50402PowerShell Script:https://silentinstall

    The information above provides a brief overview of the software title, vendor, silent install, and silent uninstall switches, as well as download links to the vendor’s website.Continue reading if you want more information and configurations.


    Additional Configurations

    Create an Installation Log File

    The Microsoft SQL Server 2012 Native Client installer provides the option to generate a log file during installation to aid in troubleshooting if any issues arise; use the following commands to generate a verbose log file with installation details.

    MSI stands for Microsoft SQL Server 2012 Native Client Silent Install with Logging.

    MsiExec.exe /i sqlncli.msi IACCEPTSQLNCLILICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\SQLNativeClient-Install.log"


    Uninstalling Microsoft SQL Server 2012 Native Client Quietly

    For a scripted solution, see the Microsoft SQL Server 2012 Native Client Install and Uninstall (PowerShell) post.

    What is the procedure for launching SQL Server Native Client?

    Download Microsoft OLE DB Driver for SQL Server — Download the Microsoft OLE DB Driver for SQL Server to create native Windows applications that connect to SQL Server and Azure SQL Database.

    What is the purpose of the Microsoft SQL Server 2012 Native Client?

    SQL Server Native Client was created to make it easier to gain native data access to SQL Server via OLE DB or ODBC.provide a simplified method of gaining native data access to SQL Server using either OLE DB or ODBC.

    How do I start SQL Server 2012 after it has been installed?

    Launch the installation wizard and follow the steps below:.

    Click setup..

    Click Installation from the left menu.

    Add features to an existing installation or create a new SQL Server stand-alone installation.

    The Setup Support Rules wizard is launched by the installation wizard..

    Enter your license key in the Product Key screen.

    What happened to my SQL Server Native Client?

    SQL Server Native Client..

    Method 1: Start the ODBC Administrator (odbcad32.exe) on the system where you want to find the Native Client version, and then check the Version column under the Drivers tab.

    Method 2: In the following registry locations, look for the PatchLevel or Version keys: SQL version /.

Where to download the ODBC Drivers and OLEDB Providers for the different versions of SQL Server Native Client?

There are different versions of the Native Client components for each SQL Server.

  • SQL Server 2005 — Native Client 9.0
  • SQL Server 2008 — Native Client 10.0
  • SQL Server 2012 — Native Client 11.0

The components have been distributed through SQL Server «Feature Packs» and there are new versions of those «Feature Packs» for each Service Pack release of SQL Server.

This page lists instructions and download links for each version of the Native Client OLE DB providers and ODBC drivers and for each Feature Pack distribution package. If you find something is missing, let us know here!

Download SQL Server 2005 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within the «Feature Pack for Microsoft SQL Server 2005».
There are four versions of this Feature Pack. The latest is the «December 2008» package.

The package contains:

  • SQL Native Client 9.0 OLE DB Provider — «SQLNCLI»
  • SQL Native Client 9.0 ODBC Driver — «{SQL Native Client}»

Download Instructions

First navigate to one of the download links below, then:

  • Hit Download button.
  • Checkbox one of the installation packages (msi). Make sure you choose the right version:
    • sqlncli.msi for 32-bit
    • sqlncli_x64.msi for 64-bit
    • sqlncli_ia64.msi for Itanium
  • Click Next.
  • Download starts.

Feature Pack for SQL Server 2005 — download links

  • Feature Pack for Microsoft SQL Server 2005 — December 2008 (latest)
  • Feature Pack for Microsoft SQL Server 2005 — February 2007
  • Feature Pack for Microsoft SQL Server 2005 — April 2006
  • Feature Pack for Microsoft SQL Server 2005 — November 2005

Download SQL Server 2008 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 «Feature Packs».
There are different «Feature Packs» for each SQL Server 2008 service pack version.

The package contains:

  • SQL Server Native Client 10.0 OLE DB Provider — «SQLNCLI10»
  • SQL Server Native Client 10.0 ODBC Driver — «{SQL Server Native Client 10.0}»

Download Instructions

First navigate to one of the download links below, then:

  • Hit Download button.
  • Checkbox one of the «sqlncli.msi» installation packages. Make sure you choose the right version:
    • x86 for 32-bit
    • x64 for 64-bit
    • IA64 for Itanium
  • Click Next.
  • Download starts.

Feature Pack for SQL Server 2008 — download links

  • SQL Server 2008 SP3 Feature Pack
  • SQL Server 2008 SP2 Feature Pack
  • SQL Server 2008 SP1 Feature Pack — NO LONGER AVAILABLE
  • SQL Server 2008 Feature Pack — NO LONGER AVAILABLE

Download SQL Server 2008 R2 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 R2 «Feature Packs».
There are different «Feature Packs» for each SQL Server 2008 R2 service pack version.

The package contains:

  • SQL Server Native Client 10.0 OLE DB Provider — «SQLNCLI10»
  • SQL Server Native Client 10.0 ODBC Driver — «{SQL Server Native Client 10.0}»

Download Instructions

First navigate to one of the download links below, then:

  • Hit Download button.
  • Checkbox one of the «sqlncli.msi» installation packages. Make sure you choose the right version:
    • sqlncli_x86.msi for 32-bit
    • sqlncli_amd64.msi for 64-bit
    • sqlncli_ia64.msi for Itanium
  • Click Next.
  • Download starts.

Feature Pack for SQL Server 2008 R2 — download links

  • SQL Server 2008 R2 SP2 Feature Pack
  • SQL Server 2008 R2 SP1 Feature Pack
  • SQL Server 2008 R2 Feature Pack

Download SQL Server 2012 Native Client ODBC & OLEDB

Booth the ODBC driver and the OLEDB provider have been released within the «Microsoft SQL Server 2012 Feature Pack«.
There are currently only one «Feature Pack» for SQL Server 2012.

The package contains:

  • SQL Server Native Client 11.0 OLE DB Provider — «SQLNCLI11»
  • SQL Server Native Client 11.0 ODBC Driver — «{SQL Server Native Client 11.0}»

Download Instructions

First navigate to one of the download links below, then:

  • Do NOT hit the Download button
  • Expand the «Install Instructions» section
  • Scroll down to the «MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS» section (it’s far down)
  • Under the «Microsoft SQL Server 2012 Native Client» heading, click one of the «sqlncli.msi» installation package links. Make sure you choose the right version:
    • X86 Package for 32-bit
    • X64 Package for 64-bit
    • seems there are no link for the Itanium CPU architecture
  • Download starts.

Feature Pack for SQL Server 2012 — download links

  • SQL Server 2012 Feature Pack

Summary

This page aims to provide all information needed to obtain the correct Native Client ODBC Driver or Native Client OLEDB Provider for connections to SQL Server. If any info on this page is not up to date, not correct, unclear or could be more precise, let us know buy sending us info through this form. Thanks!

  • Microsoft solitaire collection скачать для windows 10 скачать бесплатно
  • Microsoft solitaire collection скачать для windows 10 без регистрации
  • Microsoft security essentials windows 7 что это
  • Microsoft security essentials windows 7 старая версия
  • Microsoft solitaire collection не запускается на windows 10