Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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

• The Microsoft SQL Server 2014 SP2 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 2014 SP2.
  • Add-on providers for Microsoft SQL Server 2014 SP2.
  
  

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
ENU/DB2OLEDBV6_x64.msi SHA1: 13a42b3f464bbba9748cce38903c54eebb0808bf	3.53 MB
ENU/DB2OLEDBV6_x86.msi SHA1: eaf5df73e83e8168d6a89cf2be901feeb6a4dc7f	2.07 MB
ENU/x64/BalancedDataDistributor-amd64.msi SHA1: af33981df12b7bf482bc080e9a6a6569f3668ddd	586 KB
ENU/x64/MasterDataServicesExcelAddin.msi SHA1: 7b44b68adee469a3befafb2603b63a98c0091801	1.47 MB
ENU/x64/MsSqlCmdLnUtils.msi SHA1: 9f0127fa9f732199b46f0d7a737bcf423ccea5e8	1.21 MB
ENU/x64/PowerShellTools.msi SHA1: db10f99b537821ebaca82d9430aee595bcde8b74	882 KB
ENU/x64/RBS.msi SHA1: ac4a5c879af0eeed051825b8dc25f2417f1cebc1	1.54 MB
ENU/x64/rsSharePoint.msi SHA1: de1e4bd6e6b7911f598f2b37249ca4043b39339e	53.08 MB
ENU/x64/SapBI.msi SHA1: 3266f48f549fa4a09e4c604299b6c6ac6874b60c	967 KB
ENU/x64/SharedManagementObjects.msi SHA1: 2754c510eb14ccabf5e57e784a7e69b845531b5b	6.13 MB
ENU/x64/spPowerPivot.msi SHA1: 046f1b9300ba218e1e7d46a0bb5e4bca4a129ab1	81.85 MB
ENU/x64/SqlCloudAdapter.msi SHA1: 0ca3286f6fa4805104e5f32f747df4d1859a82f2	769 KB
ENU/x64/SqlDom.msi SHA1: 82e7c4db9373ef6ed883ca9fd92e3793d0fb60a9	1.51 MB
ENU/x64/sqlls.msi SHA1: facab96d4b6e257218c672bff8d3ee946baf843a	31.92 MB
ENU/x64/SQLSysClrTypes.msi SHA1: c7457913643083c0a1c27e637f8e9043b3e94e66	2.11 MB
ENU/x64/SqlUA.msi SHA1: 519ba046d8542526e7c50b4f8b9ddce69705e1e7	10.96 MB
ENU/x64/SQL_AS_ADOMD.msi SHA1: 3172c5e900d2552a973685d3430ff19736df0ac6	4.30 MB
ENU/x64/SQL_AS_AMO.msi SHA1: 22be7a4a91dba4ed6558102c4f3f1ffce054536e	2.89 MB
ENU/x64/SQL_AS_OLEDB.msi SHA1: 4ae6addb73681ad6cbf8011837b244991d68d1b1	52.00 MB
ENU/x64/SSBEAS.msi SHA1: 4cd18e3a856335ff1020f9602a19c2abd7ca478c	1.08 MB
ENU/x64/StreamInsight.msi SHA1: 5098ed7c9767c365937e88f2f386b2836af4bede	10.55 MB
ENU/x64/StreamInsightClient.msi SHA1: ea829aa0010d201e2af7efe4886cfa2155fabc6e	9.67 MB
ENU/x64/TSqlLanguageService.msi SHA1: 1ec509268e1c6fb3ea70322e15e26a55939a1a37	1.78 MB
ENU/x86/BalancedDataDistributor-x86.msi SHA1: dc2ece4dccbe7efa7086188b07e3100b1dcdfdb9	507 KB
ENU/x86/MasterDataServicesExcelAddin.msi SHA1: 831a5fc677276c0ae5eb2d4467f0ad17e7737fa1	1.43 MB
ENU/x86/MsSqlCmdLnUtils.msi SHA1: b831fb393a0f3cdc117d92a1740b1ff9c059ce7d	1.11 MB
ENU/x86/PowerShellTools.msi SHA1: 56d06260024638518ca8d708e1b10c2996b9dae7	826 KB
ENU/x86/RBS.msi SHA1: bb6495f0b3f3d95cb8b9fa1fd1b2016dbe7f1032	1.36 MB
ENU/x86/SapBI.msi SHA1: 7dbb343afb2ca676ee14e767508e5599bc59de73	899 KB
ENU/x86/SharedManagementObjects.msi SHA1: c07b882538863a2b125a2eda29d269d803cd0f0d	5.26 MB
ENU/x86/SqlDom.msi SHA1: 88252ba22646a65c3e38f91476a39f1cc2691803	1.46 MB
ENU/x86/sqlls.msi SHA1: 1f84e741062d810723df2cacef55186ec5b8d0f7	14.90 MB
ENU/x86/SQLSysClrTypes.msi SHA1: 4175191dafa15d582c2438daaa9e1ee19d68ab63	1.37 MB
ENU/x86/SqlUA.msi SHA1: 94ad73ac8718f373a395bd5bed17c3ce92677b6f	7.22 MB
ENU/x86/SQL_AS_ADOMD.msi SHA1: 02b87651d4df2ee7769c0fbb285cd7ded2aa7dc7	1.79 MB
ENU/x86/SQL_AS_AMO.msi SHA1: 97cb8c175a8ddfee81118f24b633d4ccc9adb55b	1.91 MB
ENU/x86/SQL_AS_OLEDB.msi SHA1: 25505539bf405d11ab127d7f144f144804037cc8	23.59 MB
ENU/x86/SSBEAS.msi SHA1: 9229e40c1eab199e4fe6577712ec4d85d474442c	1.02 MB
ENU/x86/StreamInsight.msi SHA1: cdd85e8b75a12a0898379453885b63e5f162a57e	7.61 MB
ENU/x86/StreamInsightClient.msi SHA1: 09a0754ada9d52e1b7141b21ddb93a362c9ea2d6	6.82 MB
ENU/x86/TSqlLanguageService.msi SHA1: aeaa3fd51dbe11f8b2fb8ba99d2d3bc3fde55493	1.75 MB
ODataSourceForSQLServer2014-amd64.msi SHA1: 18fcf6f5043b21f2e2c8842c708d0bae3018eb29	1.16 MB
ODataSourceForSQLServer2014-x86.msi SHA1: 89f08645b9e9d6c75676f5a3138a6c2135db06bc	1.12 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

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

• 
  MICROSOFT SQL SERVER DATABASE SYSTEMS FEATURE PACK COMPONENTS
  
  
  
  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® SQL Server® Cloud Adapter
  SQL Server Cloud Adapter is a service running on the same machine where SQL Server instances are running and helping discovering and configuring those.
  
  Filename: x64 Package(SqlCloudAdapter.msi)
  
  
  
  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® 2014 SP2 Semantic Language Statistics
  
  The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014 SP2. You can download this database from this page, attach it to your SQL Server 2014 SP2 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, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005, through SQL Server Data Tools and SQL Server Management Studio.
  Note: Microsoft SQL Server 2014 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® 2014 SP2 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 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.
  
  Filename: X86 and x64 Package(tsqllanguageservice.msi)
  
  
  
  
  Microsoft® Windows PowerShell Extensions for Microsoft SQL Server® 2014 SP2
  The Microsoft Windows PowerShell Extensions for SQL Server 2014 SP2 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 2014 SP2 requires Microsoft SQL Server 2014 SP2 Shared Management Objects, also available on this page. This component also requires Windows PowerShell 2.0; download instructions are on the Windows Server 2003 Web site.
  
  Filename: X86 and x64 Package(PowerShellTools.msi)
  
  
  
  Microsoft® SQL Server® 2014 SP2 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. This object model will work with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.
  
  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® Command Line Utilities 11 for Microsoft 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 Driver 11 for Microsoft SQL Server® - Windows
  The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database.
  
  
  
  Microsoft® JDBC Drivers for Microsoft SQL Server®
  In our continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The Microsoft JDBC Drivers for SQL Server are available to all SQL Server users at no additional charge, and provides access to SQL Server 2012 and other versions from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC Application Program Interfaces (APIs) available in Java Platform, Enterprise Editions 5 and 6. This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or 6.0. It has been tested against major application servers including IBM WebSphere, and SAP NetWeaver.
  
  
  
  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® 2014 SP2 Transact-SQL ScriptDom
  Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 versions.
  
  Filename: X86 and x64 Package(SQLDOM.MSI)
  
  
  
  
  Microsoft® SQL Server® 2014 SP2 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® 2014 SP2
  The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2014. 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® 2014 SP2 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)
  
  SQL RBS codeplex samples page
  
  
  SQL Server Remote Blob Store blogs
  
  
  
  Microsoft® SQL Server® Service Broker External Activator for Microsoft SQL Server 2014 SP2
  The Microsoft SQL Server Service Broker External Activator is an extension of the internal activation feature in SQL Server 2014 SP2 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. By doing this, cpu-intensive or long-duration tasks can be offloaded out of SQL Server to an application executable, possibly in another computer. The application executable can also run under a different Windows account from the Database Engine process. This gives administrators additional control over the resources that the application can access. The single setup program will install the service on x86, and x64 computers.
  
  Filename: X86 and x64 Package(SSBEAS.msi)
  
  
  
  MICROSOFT SQL SERVER INTEGRATION SERVICES FEATURE PACK COMPONENTS
  
  
  
  Microsoft® OData Source for Microsoft SQL Server® 2014 SP2
  The Microsoft OData Source for SQL Server 2014 SP2 is a SQL Server Integration Services (SSIS) source component, which connects and consumes data from Open Data Protocol (OData). The SSIS component is designed to be used with SQL Server Integration Services. To install the component, run the platform-specific installer for x86 and x64 respectively.
  
  Filename (X86 Package)(ODataSourceForSQLServer2014-x86.msi)
  Filename (X64 Package)(ODataSourceForSQLServer2014-amd64.msi)
  
  
  
  Microsoft® Balanced Data Distributor for Microsoft SQL Server® 2014 SP2
  Microsoft SSIS Balanced Data Distributor (BDD) is a SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading.
  
  Filename (X86 Package)(BalancedDataDistributor-x86.msi)
  Filename (X64 Package)(BalancedDataDistributor-amd64.msi)
  
  
  
  Microsoft® Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server® 2014 SP2
  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 2014 SP2 tables as well as capture changes from your Oracle database and send them to SQL Server 2014 SP2 databases to keep data warehouses in sync.
  
  Filename (X86 and X64 Package)(AttunityOraleCdcService.msi)
  Filename (X86 and X64 Package)(AttunityOraleCdcDesigner.msi)
  
  
  Microsoft® SQL Server® 2014 SP2 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® SQL Server® StreamInsight
  
  Microsoft® StreamInsight is Microsoft’s Complex Event Processing technology to help businesses create event-driven applications and derive better insights by correlating event streams from multiple sources with near-zero latency.
  
  Filename: X86 and x64 Package(StreamInsight.msi)
  Filename: X86 and x64 Package(StreamInsightClient.msi)
  
  
  
  Microsoft® Connector for SAP BW for Microsoft SQL Server® 2014
  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 2014 SP2 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® Migration Assistant
  SQL Server Migration Assistant (SSMA) is a family of products to reduce the cost and risk of migration from Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.
  
  1. Microsoft SQL Server Migration Assistant for Access
  2. Microsoft SQL Server Migration Assistant for MySQL
  3. Microsoft SQL Server Migration Assistant for Oracle
  4. Microsoft SQL Server Migration Assistant for Sybase
  
  
  
  
  Microsoft® SQL Server® 2014 SP2 Upgrade Advisor
  Microsoft Upgrade Advisor analyzes instances of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 in preparation for upgrading to SQL Server 2014. 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.
  Filename: X86 and x64 Package(SQLUA.msi)
  
  Note: The Upgrade Advisor Tool is provided ‘as is’ and is not supported by Microsoft Support Services. For additional assistance with the tool please use the SQL Server Setup & Upgrade Forum
  
  
  
  Microsoft® OLEDB Provider for DB2 v5.0 for Microsoft SQL Server® 2014 SP2
  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 SQL SERVER BUSINESS INTELLIGENCE FEATURE PACK COMPONENTS
  
  
  Microsoft® SQL Server® 2014 SP2 PowerPivot® for Microsoft SharePoint 2013
  
  Microsoft SQL Server 2014 SP2 PowerPivot for SharePoint 2013 extends SharePoint Server 2013 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks and Excel workbooks with advanced data models to SharePoint. This package is only available in a 64-bit version.
  
  
  
  Microsoft® SQL Server® 2014 SP2 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 2014 SP2 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 2014 SP2 languages.
  
  Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)
  
  
  
  Microsoft® Analysis Services OLE DB Provider for Microsoft SQL Server® 2014 SP2
  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 2014 SP2 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® 2014 SP2 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 2014 SP2
  
  Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2014 SP2 Reporting Services. The download provides a stand-alone installer for Report Builder.
  
  
  
  Microsoft® SQL Server® 2014 SP2 Reporting Services Add-in for Microsoft SharePoint®
  The Microsoft SQL Server 2014 SP2 Reporting Services Add-in for Microsoft SharePoint allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint.