Chocolatey Fest - Chocolatey's inaugural conference on Windows Automation (WinOps) is coming - Learn more!

Microsoft SQL Server 2008 R2 Native Client


Package test results are passing.

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package was approved by moderator gep13 on 5/17/2018.

Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library
(DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for
applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000,
2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing
applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer
for SQL Server Native Client installs the client components needed during run time to take advantage of new
SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that
uses the SQL Server Native Client API.

To install Microsoft SQL Server 2008 R2 Native Client, run the following command from the command line or from PowerShell:

C:\> choco install sql2008r2.nativeclient

To upgrade Microsoft SQL Server 2008 R2 Native Client, run the following command from the command line or from PowerShell:

C:\> choco upgrade sql2008r2.nativeclient


  • tools\chocolateybeforemodify.ps1 Show
    # This runs in 0.9.10+ before upgrade and uninstall.
    # Use this file to do things like stop services prior to upgrade or uninstall.
    # NOTE: It is an anti-pattern to call chocolateyUninstall.ps1 from here. If you
    #  need to uninstall an MSI prior to upgrade, put the functionality in this
    #  file without calling the uninstall script. Make it idempotent in the
    #  uninstall script so that it doesn't fail when it is already uninstalled.
    # NOTE: For upgrades - like the uninstall script, this script always runs from 
    #  the currently installed version, not from the new upgraded package version.
  • tools\chocolateyinstall.ps1 Show
    $ErrorActionPreference = 'Stop'; 
    $toolsDir   = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
    $url        = ''
    $checksum   = '35c4b98f7f5f951cae9939c637593333c44aee920efbd4763b7bdca1e23ac335'
    $url64bit   = ''
    $checksum64 = '012aca6cef50ed784f239d1ed5f6923b741d8530b70d14e9abcb3c7299a826cc'
    $packageArgs = @{
      packageName    = $env:ChocolateyPackageName
      fileType       = 'msi'
      url            = $url
      checksum       = $checksum
      checksumType   = 'sha256' 
      url64bit       = $url64bit
      checksum64     = $checksum64
      checksumType64 = 'sha256'
      silentArgs     = "/qb /norestart /l*v `"$($env:TEMP)\$($packageName).log`" IACCEPTSQLNCLILICENSETERMS=YES" 
      validExitCodes = @(0, 3010, 1641)
    Install-ChocolateyPackage @packageArgs
  • tools\chocolateyuninstall.ps1 Show
    $ErrorActionPreference = 'Stop';
    # HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
    # HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\
    $msiId       = '{4AB6A079-178B-4144-B21F-4D1AE71666A2}'
    $msiId64     = '{2180B33F-3225-423E-BBC1-7798CFD3CD1F}'
    $packageName = 'SQL2008R2.NativeClient'
    $uninstalled = $false
    [array]$key = Get-UninstallRegistryKey -SoftwareName 'SQL Server 2008 R2 Native Client*'
    if ($key.Count -eq 1) {
      $key | ForEach-Object {
      $packageArgs = @{
        packageName    = $packageName
        fileType       = 'MSI'
        silentArgs     = '/qb'
        validExitCodes = @(0)
        file           = "$($_.UninstallString)"
        Uninstall-ChocolateyPackage @packageArgs
    } elseif ($key.Count -eq 0) {
      Write-Warning "$packageName has already been uninstalled by other means."
    } elseif ($key.Count -gt 1) {
      Write-Warning "$($key.Count) matches found!"
      Write-Warning "To prevent accidental data loss, no programs will be uninstalled."
      Write-Warning "Please alert package maintainer the following keys were matched:"
      $key | ForEach-Object {Write-Warning "- $($_.DisplayName)"}

Virus Scan Results

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.


This package has no dependencies.

Package Maintainer(s)

Software Author(s)

  • Microsoft


Copyright © XXXXX


Release Notes

Version History

Version Downloads Last updated Status
Microsoft SQL Server 2008 R2 Native Client 10.50.1600.2 31331 Thursday, January 17, 2013  
Microsoft SQL Server 2008 R2 Native Client 10.50.1600.1 1184 Wednesday, January 16, 2013  

Discussion for the Microsoft SQL Server 2008 R2 Native Client Package

Ground rules:

  • This discussion is only about Microsoft SQL Server 2008 R2 Native Client and the Microsoft SQL Server 2008 R2 Native Client package. If you have feedback for Chocolatey, please contact the google group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or Microsoft SQL Server 2008 R2 Native Client, or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.

comments powered by Disqus uses cookies to enhance the user experience of the site.