Microsoft Download Center Archive

Microsoft® SQL Server® 2016 Feature Pack

  • Published:
  • Version: 13.0.1601.5
  • Category: Redistributable Component
  • Language: English

The Microsoft SQL Server 2016 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server.

  • The Microsoft SQL Server 2016 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes the latest versions of:
    • Tool and components for Microsoft® SQL Server 2016.
    • Add-on providers for Microsoft SQL Server 2016


    Please reference the Instructions section of this page to learn more about each component.

Files

Status: Deleted

This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020.

FileSize
ENU/x64/AttunityOracleCdcDesigner.msi
SHA1: b64777257d4a82c7b0ebcfb5c1ff5d4750a71896
1.03 MB
ENU/x64/AttunityOracleCdcService.msi
SHA1: 55314227b4d9803f24d88d5d7f1ead2ab4725208
1.11 MB
ENU/x64/DB2OLEDBV5_x64.msi
SHA1: 96eb03d8d00156153046af9b021121cd64126a13
2.75 MB
ENU/x64/MasterDataServicesExcelAddin.msi
SHA1: 261ff3874dff37c035e7d7b8a1c8d5f7ade15f14
1.96 MB
ENU/x64/msodbcsql.msi
SHA1: 117f156e492b4496e1b8b5da949d94d97231ccc1
3.02 MB
ENU/x64/MsSqlCmdLnUtils.msi
SHA1: 05ebd7f0c5d36bb0fb522e75211b1a46e2bb38c4
1.38 MB
ENU/x64/PowerShellTools.msi
SHA1: b91a5793a55ebe76af785a7cdd55b9ba32d5ce49
1.60 MB
ENU/x64/RBS.msi
SHA1: 0d1a7f79e353340f4fbbf139e6437137dae7a2e7
1.38 MB
ENU/x64/rsSharePoint.msi
SHA1: f68bb2ab8f3378300923d304bafc1c2316b55205
45.44 MB
ENU/x64/SapBI.msi
SHA1: 63a16f587267f5ed7bccd8a87813b0e13b9dba11
1.04 MB
ENU/x64/SemanticLanguageDatabase.msi
SHA1: cb298e214292fd5e49ed342c18387f56b0dd1ae0
176.27 MB
ENU/x64/SharedManagementObjects.msi
SHA1: 70aa73f05fcec68e0601245784baf1d3f0fd9472
5.13 MB
ENU/x64/spPowerPivot.msi
SHA1: 1d5fe9e841cde957f21067f4901e997d3bbd44d8
81.44 MB
ENU/x64/spPowerPivot16.msi
SHA1: a8a6147d5810ac30db38988fcc86bfad73257763
97.26 MB
ENU/x64/SqlDom.msi
SHA1: 5daa89c135d356c5d073a817f82260dc36645a1a
1.69 MB
ENU/x64/sqlls.msi
SHA1: 8582d29dfb16957b35b9947010ce96fa0585f8bd
34.06 MB
ENU/x64/sqlncli.msi
SHA1: 9895a0e95b2db22cf5eae750217430376781b485
3.72 MB
ENU/x64/SQLSysClrTypes.msi
SHA1: cc540fb1492047c4e2a61cd6e86f60acb67ced8c
2.50 MB
ENU/x64/SQL_AS_ADOMD.msi
SHA1: a113779140a597d439ddbb3e132db24e0b975876
3.73 MB
ENU/x64/SQL_AS_AMO.msi
SHA1: eb68e1d119aa6b66bf7ef0070982a0debc0e5617
5.15 MB
ENU/x64/SQL_AS_OLEDB.msi
SHA1: aad4e0208df1f077da474f90f247d0867894e5cc
60.99 MB
ENU/x64/sql_fulltext.msi
SHA1: 8b4477de204f3818bf18a0fe1414581e5277c5a5
143.39 MB
ENU/x64/SSBEAS.msi
SHA1: 9578508cdda9b2a1e612c715adcd5edab661e8de
1.13 MB
ENU/x64/SsisAzureFeaturePack_2016_x64.msi
SHA1: 3d9403d9f0db547843e1cba06c4920150b93ac5f
2.52 MB
ENU/x64/TSqlLanguageService.msi
SHA1: 981e2d7a09a95a1af2337f98e92b35166342847f
2.31 MB
ENU/x86/AttunityOracleCdcDesigner.msi
SHA1: 7de1a3b23ea32924514a4aabfe51e196b7c07a8f
997 KB
ENU/x86/AttunityOracleCdcService.msi
SHA1: d9dfd8107b4943e64983ab816f51c5c7e32eb748
1.05 MB
ENU/x86/DB2OLEDBV5_x86.msi
SHA1: 72e759fbf68072f902d430d21552a68896a84604
1.70 MB
ENU/x86/MasterDataServicesExcelAddin.msi
SHA1: acac43f9f946cb1e0044371919345e2b13933d81
1.92 MB
ENU/x86/msodbcsql.msi
SHA1: 0e36e08dd2746b955177fb98723b0e073bc37eff
1.71 MB
ENU/x86/MsSqlCmdLnUtils.msi
SHA1: e0450e0c1076741eb2716d9c5438b053cd734e4b
1.28 MB
ENU/x86/PowerShellTools.msi
SHA1: 6ffafdd665b0c82a745b3707eecba5a4be6c4bbb
1.55 MB
ENU/x86/RBS.msi
SHA1: c4dcf715d465349165c92a726d40957ea3b6575a
1.39 MB
ENU/x86/ReportBuilder3.msi
SHA1: 587d9980ad9989170c57f12fb54dfdf7b9094222
21.16 MB
ENU/x86/ReportViewer.msi
SHA1: 2fcb09886231109f24c120fe94ef6e9596c6244a
5.77 MB
ENU/x86/SapBI.msi
SHA1: 842a810677dc9edd871165b468de6408062ba9b8
922 KB
ENU/x86/SemanticLanguageDatabase.msi
SHA1: 8e686a149d228a7b307203820c668c92d26088c4
176.24 MB
ENU/x86/SharedManagementObjects.msi
SHA1: 6bc6b3b4445865c209bd7fdc05708929444b1956
4.31 MB
ENU/x86/SqlDom.msi
SHA1: 2388c6a84163d75ba180d177b7ecf5d80337c8cb
1.20 MB
ENU/x86/sqlls.msi
SHA1: a593f65c6b26798e463cb537fbcb040273c7cfb0
15.90 MB
ENU/x86/sqlncli.msi
SHA1: 59b30bfcc9556a07282d8e771486c16a02f6585d
2.05 MB
ENU/x86/SQLSysClrTypes.msi
SHA1: 4c14e2963e37b8bb3af2f339369d992126bf965f
1.70 MB
ENU/x86/SQL_AS_ADOMD.msi
SHA1: 1e54257e2e0f11213cf75c37052cb0a3cfa13287
2.06 MB
ENU/x86/SQL_AS_AMO.msi
SHA1: 85f9d2c2c838a423764886f7e54ac86d76a781f9
2.91 MB
ENU/x86/SQL_AS_OLEDB.msi
SHA1: 581f12d43bcd8ab1863c7d28c45ca475634153bb
28.81 MB
ENU/x86/sql_fulltext.msi
SHA1: de0863779c1244328089bbeabc62b09cbf520ebc
140.90 MB
ENU/x86/SSBEAS.msi
SHA1: 597e3775b044a10d9de1b8c7ad7ab965a86b6853
1.07 MB
ENU/x86/SsisAzureFeaturePack_2016_x86.msi
SHA1: 1c7cd63cc4a5bdfdc18749192de0f8031e246a7f
2.49 MB
ENU/x86/TSqlLanguageService.msi
SHA1: 8014b1a49e37ceba2a9936aac42680481f70e789
2.28 MB

System Requirements

Operating Systems: Windows 10, Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016


  • Note:System requirements vary among the install packages included in the Feature Pack.
    Note: When an MSI package is redistributed it must not be renamed, otherwise you may see failures if updates are installed for that package.

Installation Instructions


  • Microsoft® SQL Server® 2016 Master Data Service Add-in for Microsoft Excel®
      The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.

      The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency. Manage MDS data within an interface you already know and love Microsoft Excel. Leverage existing Excel functionality to share your managed lists with others, knowing these lists can be secured and monitored with all of the features provided by Master Data Services.


    Microsoft® Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server® 2016
      Microsoft Change Data Capture Designer and Service for Oracle by Attunity allow you to continually copy data from Oracle to SQL Server. This can be useful in both migration and data warehouse scenarios by allowing you to both; synchronize critical tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server tables as well as capture changes from your Oracle database and send them to SQL Server databases to keep data warehouses in sync.
        Filename X86 and X64 Package (AttunityOraleCdcService.msi)
        Filename X86 and X64 Package (AttunityOraleCdcDesigner.msi)


    Microsoft® Connector for SAP BW for Microsoft SQL Server® 2016
      The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with SQL Server Integration Services. To install the component, run the platform-specific installer for x86 or x64 respectively. For more information see the Readme and the installation topic in the Help file.
        Filename: X86 and x64 Package (SAPBI.msi)



    Microsoft® SQL Server® 2016 ADOMD.NET
      ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2016 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.

      Note:The English ADOMD.NET setup package installs support for all SQL Server 2016 languages.
        Filename: X86 and x64 Package (SQL_AS_ADOMD.msi)


    Microsoft® Analysis Services OLE DB Provider for Microsoft SQL Server® 2016
      The Analysis Services OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2016 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.

      Note: Microsoft Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0
        Filename: X86 and x64 Package (SQL_AS_OLEDB.msi)


    Microsoft® SQL Server® 2016 Analysis Management Objects
      Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects.
        Filename: X86 and x64 Package (SQL_AS_AMO.msi)

    Microsoft® SQL Server® Report Builder for Microsoft SQL Server 2016
      Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2016 Reporting Services. The download provides a stand-alone installer for Report Builder.

    Microsoft® SQL Server® 2016 Reporting Services Add-in for Microsoft SharePoint®
      Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.

    Microsoft® SQL Server® 2016 PowerPivot® for Microsoft SharePoint® 2013
      Microsoft SQL Server 2016 PowerPivot for SharePoint 2013 extends SharePoint Server 2013 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.

    Microsoft® SQL Server® 2016 PowerPivot® for Microsoft SharePoint® 2016
      Microsoft SQL Server 2016 PowerPivot for SharePoint 2016 extends SharePoint Server 2016 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.


    Microsoft® JDBC Drivers for Microsoft SQL Server®
      The Microsoft JDBC Driver for SQL Server provides access to SQL Server from any Java application, application server, or Java-enabled applet.


    Microsoft® Command Line Utilities 13 for SQL Server®
      The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.


    Microsoft® ODBC Drivers for Microsoft SQL Server®
      The Microsoft ODBC Drivers for SQL Server provides native connectivity from Windows and Unix to Microsoft SQL Server and Microsoft Azure SQL Database.


    Microsoft® Drivers for PHP for Microsoft® SQL Server®
      The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later.



    Microsoft® SQL Server® Backup to Windows® Azure® Tool
      Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.


    Microsoft® Kerberos Configuration Manager for Microsoft SQL Server®
      Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.


    Microsoft® SQL Server® 2016 Semantic Language Statistics
      The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2016. You can download this database from this page, attach it to your SQL Server 2016 instance, and register it to use the new Semantic Search features.

    Microsoft® SQL Server® Data-Tier Application Framework
      The SQL Server Data-tier Application (DAC) framework is a component based on the .NET Framework that provides application lifecycle services for database development and management. Application lifecycle services include extract, build, deploy, upgrade, import, and export for data-tier applications in SQL Azure, and SQL Server.
      Note: Microsoft SQL Server 2016 Data-tier Application Framework requires Microsoft SQL Server System CLR Types, and Microsoft SQL Server Transact-SQL ScriptDom both of which are available on this page.



    Microsoft® SQL Server® 2016 Transact-SQL Language Service
      The SQL Server Transact-SQL Language Service is a component based on the .NET Framework which provides parsing validation and IntelliSense services for Transact-SQL for SQL Server.
        Filename: X86 and x64 Package (tsqllanguageservice.msi)



    Microsoft® Windows PowerShell Extensions for Microsoft SQL Server® 2016
      The Microsoft Windows PowerShell Extensions for SQL Server includes a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server. The SQL Server PowerShell Provider delivers a simple mechanism for navigating SQL Server instances that is similar to file system paths. PowerShell scripts can then use the SQL Server Management Objects to administer the instances. The SQL Server cmdlets support operations such as executing Transact-SQL scripts or evaluating SQL Server policies.

      Note: Windows PowerShell Extensions for SQL Server 2016 requires Microsoft SQL Server 2016 Shared Management Objects.
        Filename: X86 and x64 Package (PowerShellTools.msi)


    Microsoft® SQL Server® 2016 Shared Management Objects
      SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services.

      Note: Microsoft SQL Server Management Objects requires - Microsoft SQL Server System CLR Types, that is available on this page.
        Filename: X86 and x64 Package (SharedManagementObjects.msi)


    Microsoft® SQL Server® 2016 Transact-SQL ScriptDom
      Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL.
        Filename: X86 and x64 Package (SQLDOM.MSI)



    Microsoft® SQL Server® 2016 Transact-SQL Compiler Service
      Microsoft SQL Server Transact-SQL Compiler Service is a set of components that provide the compilation and validation services for Transact-SQL. This component can be used only via the Microsoft SQL Server Data-Tier Application Framework build API.
        Filename: X86 and x64 Package (SQLLS.MSI)



    Microsoft® System CLR Types for Microsoft SQL Server® 2016
      The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server. This component can be installed separately from the server to allow client applications to use these types outside of the server.

      Note: This component also requires Windows Installer 4.5
        Filename: X86 and x64 Package (SQLSysClrTypes.msi)


    Microsoft® SQL Server® 2016 Remote Blob Store
      The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder.
        Filename: X86 and x64 Package (RBS.msi)


    Microsoft® SQL Server® Service Broker External Activator for Microsoft SQL Server 2016
      The Microsoft SQL Server Service Broker External Activator is an extension of the internal activation feature in SQL Server that lets you move the logic for receiving and processing Service Broker messages from the Database Engine service to an application executable that runs outside SQL Server.
        Filename: X86 and x64 Package (SSBEAS.msi)


    Microsoft® SQL Server® Upgrade Advisor
      Microsoft Upgrade Advisor analyzes instances of SQL Server in preparation for upgrading to SQL Server 2016. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.


    Microsoft® OLEDB Provider for DB2 v5.0 for Microsoft SQL Server®
      The Microsoft OLE DB Provider for DB2 v5.0 offers a set of technologies and tools for integrating vital data stored in IBM DB2 databases with new solutions. SQL Server developers and administrators can use the data provider with integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Read the Installing Data Provider section of the product documentation, which is available on-line or as a download.
        Filename: X86 and x64 Package (DB2OLEDB5_x86.msi and DB2OLEDB5_x64.msi)


    Microsoft® Integration Services Feature Pack for Azure®
      The Microsoft Integration Services Feature Pack for Azure provides tools for using IS to connect to the Azure stack.
        Filename:SsisAzureFeaturePack_2016_x64.msi and SsisAzureFeaturePack_2016_x86.msi

What is this?

In August 2020, Microsoft deleted thousands of downloads for prior versions of Windows, Office, Visual Studio, SQL Server, and countless other products. Legacy Update has catalogued the Microsoft Download Center as it stood prior to August 2020.

Check our Microsoft Download Center Archive homepage to discover more downloads.