Microsoft Download Center Archive

Microsoft® SQL Server® 2008 R2 SP1 Feature Pack

  • Published:
  • Version: 10.50.2500.0
  • Category: Service Pack
  • Language: English

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

  • The Microsoft® SQL Server® 2008 R2 SP1 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:
  • Redistributable components for Microsoft® SQL Server® 2008 R2 SP1

  • Add-on providers for Microsoft® SQL Server® 2008 R2 SP1


  • Note: Some components in the Microsoft® SQL Server® 2008 R2 SP1 Feature Pack of SQL Server® have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server®. For more information and instructions on how to disable these features, see the SQL Server® Privacy Statement

    Note: Some components in the Microsoft® SQL Server® 2008 R2 SP1 Feature Pack of SQL Server® have two different methods to complete the installation process:
  • Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.

  • Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.


  • Each item below indicates a short description of the package, and the audience(s) for which it was intended, as follows:

    Customer: An individual may want to install this for additional licensed functionality.
    Partner: An ISV may want to ship this as a redistributable component as part of their application.
    Developer: A programmer may want to install this to support application development.

    Note: To archive a copy of the license terms, prior to accepting them, copy and paste the terms to a word processing program, then print or save the file to your favorite directory.

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
1033/IA64/PowerShellTools.msi
SHA1: 96d691ead3cbd1be2cbdc0538f738a8780d305a5
1.43 MB
1033/IA64/RBS.msi
SHA1: 86a8869a5e928a5cc75514f2ebfa89b05ec50e3c
3.05 MB
1033/IA64/SapBI.msi
SHA1: 22b7bc87b7833e3d93335b62079d6d97f555ed32
2.21 MB
1033/IA64/SharedManagementObjects.msi
SHA1: 683c342f138d7fe41a3d07fab9af65e61d3ecf31
17.28 MB
1033/IA64/SqlCmdLnUtils.msi
SHA1: 0826f03730d6383be609d2c8b096bba2c126148f
13.91 MB
1033/IA64/sqlncli.msi
SHA1: 5f88b2cefeee5e17b16fee09f1f69caf9853e8b8
8.65 MB
1033/IA64/SQLSERVER2008_ASADOMD10.msi
SHA1: 8d1da84958ed7f610f8c194b8c4a5468261b3b25
6.49 MB
1033/IA64/SQLSERVER2008_ASAMO10.msi
SHA1: 051197b955177642b249677bacf2b560741b3dd6
3.73 MB
1033/IA64/SQLSERVER2008_ASOLEDB10.msi
SHA1: 3732c7506d25f3fdcb8818d098994473fef706c7
57.04 MB
1033/IA64/SQLSysClrTypes.msi
SHA1: 434d06659cf56a85d7e559d3121180bea4bc05e2
3.38 MB
1033/IA64/SqlUA.msi
SHA1: eec7f3bc8556ad5112a7772d1adc75157e242537
9.26 MB
1033/IA64/SSBEAS.msi
SHA1: e88c68ae7900f9a9c4dc96b29168ff9f81e4b11a
1.85 MB
1033/x64/PowerShellTools.msi
SHA1: cae76e330d3a0c254e1a5449da6f9d5e09b0f69e
909 KB
1033/x64/RBS.msi
SHA1: 822b3d8b6ab560b5f7406368d9c3bc7b4476898c
2.36 MB
1033/x64/rsSharePoint.msi
SHA1: f248e4bdef2c18e394b997c068c1d61c31115682
35.33 MB
1033/x64/SapBI.msi
SHA1: 85cc2001e7a0540c9290515064615ef50c50e7bf
1.67 MB
1033/x64/SharedManagementObjects.msi
SHA1: 70199970fcee4c8e1e0f6dfb3c99fe6dbaeb447a
14.02 MB
1033/x64/SqlCmdLnUtils.msi
SHA1: 9f6d45a7dc472c4ac7006bcbe8afb82513d5dc2e
10.59 MB
1033/x64/sqlncli.msi
SHA1: 6a694d7b751372e18f00b191147d005b0b580298
6.51 MB
1033/x64/SQLSERVER2008_ASADOMD10.msi
SHA1: 4eef9df9acb234f8c6587fc3c025f6db9e2f48f5
5.33 MB
1033/x64/SQLSERVER2008_ASAMO10.msi
SHA1: e49f3125a16ce9b1ec605b7e31515d773d88986b
3.19 MB
1033/x64/SQLSERVER2008_ASOLEDB10.msi
SHA1: 67c128ac40102a63bd219ca1616ff93e55d66a55
50.39 MB
1033/x64/SQLSysClrTypes.msi
SHA1: c9934e4b220af0a38070e21892262b081eb9fadb
2.39 MB
1033/x64/SqlUA.msi
SHA1: 91cf47d4c03559507c2aa330be499c9704bfc5b5
8.72 MB
1033/x64/SSBEAS.msi
SHA1: d4a2bade832f416aa2e766aa32e5b01bc6bff93e
1.22 MB
1033/x86/PowerShellTools.msi
SHA1: ec4f72109372784188f23ea65f6bc29c139c4c64
762 KB
1033/x86/RBS.msi
SHA1: 362f1e81f41b721dc4abc24500e462c4f2cf6bb9
2.12 MB
1033/x86/ReportBuilder3.msi
SHA1: 02bbd6122be881ab814ae6b12178be9f7532f3c1
30.29 MB
1033/x86/SapBI.msi
SHA1: 55137e508dd7c78fabd6d95de7b0ec6f7416a638
1.09 MB
1033/x86/SharedManagementObjects.msi
SHA1: 258a40f21d72fb0ad731a5e7ad74ef3327ec4e51
9.31 MB
1033/x86/SqlCmdLnUtils.msi
SHA1: 78d0e5b34d0b73f47f007eace41f29581a400ac0
6.08 MB
1033/x86/sqlncli.msi
SHA1: c05f2a681ab7560d7c85436e5e9ce3ce7b4ace65
3.57 MB
1033/x86/SQLSERVER2008_ASADOMD10.msi
SHA1: fad5b17529e8bc29fa39398d21afff741eb07dd0
3.26 MB
1033/x86/SQLSERVER2008_ASAMO10.msi
SHA1: 942b5c093c77449af706e1c867378e892472ab55
1.85 MB
1033/x86/SQLSERVER2008_ASOLEDB10.msi
SHA1: c3406add5ce0aacea388d11e2619e634eb9cf622
21.99 MB
1033/x86/SQLServer2008_DMViewer.msi
SHA1: c52d98fa746edbb4cfcdf345080da204f5f1ab1e
8.31 MB
1033/x86/SQLServerBestPracticesPolicies.msi
SHA1: bedc6cf68f7505e00b1337f533de49a92c0d76ec
553 KB
1033/x86/SQLSysClrTypes.msi
SHA1: cb77672e40e213202b485a87433330c759b4b6d9
2.50 MB
1033/x86/SqlUA.msi
SHA1: 02348761b26729f25eca3d0b975dd0f2fedc5eee
8.58 MB
1033/x86/SSBEAS.msi
SHA1: 3e644fc22477397b5a400483511c8d0781f298c0
1.06 MB

System Requirements

Operating Systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista

  • Windows 7;Windows Server 2003;Windows Server 2008;Windows Server 2008 R2;Windows Vista;Windows XP
    Note: System requirements may 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.

    Note: For more information about Hardware and Software Requirements for Installing SQL Server 2008 R2, Please visit SQL Server 2008 R2 Requirement .

Installation Instructions


  • Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.

    Each item below indicates a short description of the package, and the audience(s) for which it was intended, as follows:
      Customer: An individual may want to install this for additional licensed functionality.
      Partner: An ISV may want to ship this as a redistributable component as part of their application.
      Developer: A programmer may want to install this to support application development.

      Note: To archive a copy of the license terms, prior to accepting them, copy and paste the terms to a word processing program, then print or save the file to your favorite directory.

    Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2
      Report Builder 3.0 introduces additional visualizations including maps, sparklines and databars which can help produce new insights well beyond what can be achieved with standard tables and charts. The Report Part Gallery is also included in this release - taking self-service reporting to new heights by enabling users to re-use existing report parts as building blocks for creating new reports in a matter of minutes with a “grab and go” experience. Additionally, users will experience significant performance improvements with enhancements to the ability to use Report Builder in server mode. This allows for much faster report processing with caching of datasets on the report server when toggling between design and preview modes.

      Audience(s): Customer, Partner, Developer

      Note: This component requires Microsoft .NET Framework 3.5 SP1.


        ReportBuilder3.msi


    Microsoft® SQL Server® PowerPivot for Microsoft® Excel
      Microsoft SQL Server PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within Microsoft Excel. Users can transform mass quantities of data with incredible speed into meaningful information to get the answers they need within seconds.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
      The Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010 allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint. Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site.

      Audience(s): Customer, Partner, Developer

        rsSharePoint.msi



    Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
      Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of new SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes Report Builder server mode, and the ability to launch Report Builder directly from a Report Server. The download provides a Report Viewer Web part, Web application pages, and support for using standard Windows SharePoint Services 3.0 or Microsoft Office SharePoint Services 2007.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® 2008 R2 Policies
      Microsoft SQL Server 2008 R2 Policies are examples of how you can take advantage of Policy Based Management. These policies will help you follow some of the SQL Server best practices and avoid common pitfalls. For more information, please see Administering Servers by Using Policy Based Management in SQL Server 2008 R2 Books Online.

      Note: This component also requires Windows Installer 4.5.

      Audience(s): Customer, Partner, Developer

        SQLServerBestPracticesPolicies.msi



    Microsoft® Sync Framework 2.0 Software Development Kit (SDK)
      Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services, and devices. Using Microsoft Sync Framework, developers can build applications that synchronize data from any source using any protocol over any network.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® Compact 3.5 SP2
      SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® Compact 3.5 SP2 For Windows Mobile
      SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server ®Compact 3.5 SP2 Server Tools
      SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® Compact 3.5 SP2 Books On-line
      SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® JDBC Driver 3.0
      In our continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 3.0 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2008 R2 , SQL Server 2008, SQL Server 2005 and SQL Server 2000 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 Edition 5. This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or later. It has been tested against major application servers including IBM WebSphere, and SAP NetWeaver.

      Audience(s): Partner, Developer




    Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
      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 the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file.

      Audience(s): Partner, Developer

        X86 Package(SapBI.msi)
        X64 Package (SAPBI.msi)
        IA64 Package(SAPBI.msi)




    Microsoft® System CLR Types for SQL Server® 2008 R2
      The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2. 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.

      Audience(s): Customer, Partner, Developer




    Microsoft® SQL Server® 2008 R2 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. The setup program contained there will install RBS on X86, X64, and Itanium-based computers.

      Audience(s): Developer, DBA




    Microsoft® SQL Server® 2008 R2 Books On-line
      Microsoft SQL Server 2008 R2 Books Online is the primary documentation for SQL Server. Visit the SQL Server 2008 Books Online page on the Microsoft Download Center.

      Audience(s): Developer, DBA



    Microsoft® SQL Server® 2008 R2 Upgrade Advisor
      Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. 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.

        X86 Package (SQLUA.msi)
        X64 Package (SQLUA.msi)
        IA64 Package (SQLUA.msi)



    Microsoft® SQL Server® 2008 R2 Native Client
      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.

      Audience(s): Customer, Partner, Developer

        X86 Package (sqlncli.msi)
        X64 Package (sqlncli.msi)
        IA64 Package (sqlncli.msi)



    Microsoft® Core XML Services (MSXML) 6.0 SP 1
      Microsoft Core XML Services (MSXML) 6.0 SP 1is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.

      Audience(s): Partner, Developer




    Microsoft® OLEDB Provider for DB2
      The Microsoft OLE DB Provider for DB2 Version 3.0 offers a set of technologies and tools for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 R2 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the data provider with Integration Services, Analysis Services, Replication, Reporting Services, and DistributedQuery Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the Version 3.0 provider and tools on x86, x64, and IA64 computers. Read the installation guide and release notes for more information.

      Audience(s): Customer, Developer




    Microsoft® SQL Server® 2008 R2 Command Line Utilities
      The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 and 2008 R2 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 R2 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.

      Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page).

      Audience(s): Customer, Partner, Developer

        X86 Package(SqlCmdLnUtils.msi)
        X64 Package (SqlCmdLnUtils.msi)
        IA64 Package(SqlCmdLnUtils.msi)



    Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
      The Microsoft SQL Server 2008 R2 Service Broker External Activator is an extension of the internal activation feature in SQL Server 2008 R2 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. Run the self-extracting download package to create an installation folder. Read Books Online for more information. The single setup program will install the service on x86, x64, and IA64 computers. Read the documentation for more information.

      Audience(s): Customer, Developer

        X86 Package(SSBEAS.msi)
        X64 Package (SSBEAS.msi)
        IA64 Package(SSBEAS.msi)



    Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
      The Microsoft Windows PowerShell Extensions for SQL Server2008 R2 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 requires SQL Server 2008 R2 Management Objects, also available on this page. This component also requires Windows PowerShell 1.0; download instructions are on the Windows Server 2003 Web site.

      Audience(s): Customer, Partner, Developer

        X86 Package (PowerShellTools.msi)
        X64 Package (PowerShellTools.msi)
        IA64 Package (PowerShellTools.msi)



    Microsoft® SQL Server® 2008 R2 Shared Management Objects
      The 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 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
      Note: Microsoft SQL Server 2008 R2 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page.

      Audience(s): Customer, Partner, Developer

        X86 Package (SharedManagementObjects.msi)
        X64 Package (SharedManagementObjects.msi)
        IA64 Package (SharedManagementObjects.msi)



    Microsoft® SQL Server® 2008 R2 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 2008 R2 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 2008 R2 languages.

      Audience(s): Customer, Partner, Developer

        X86 Package(SQLSERVER2008_ASADOMD10.msi)
        X64 Package (SQLSERVER2008_ASADOMD10.msi)
        IA64 Package(SQLSERVER2008_ASADOMD10.msi)



    Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
      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 2008 R2 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 SQL Server 2008 R2 Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.

      Audience(s): Customer, Partner, Developer

        X86 Package(SQLServer2008_ASOLEDB10.msi)
        X64 Package (SQLServer2008_ASOLEDB10.msi)
        IA64 Package(SQLServer2008_ASOLEDB10.msi)



    Microsoft® SQL Server® 2008 R2 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.

      Audience(s): Customer, Partner, Developer

        X86 Package(SQLSERVER2008_ASAMO10.msi)
        X64 Package (SQLSERVER2008_ASAMO10.msi)
        IA64 Package(SQLSERVER2008_ASAMO10.msi)


    Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
      The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2008 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.

      Audience(s): Customer, Partner, Developer

        X86 Package(SQLSERVER2008_ DMViewer.msi)


    Microsoft® SQL Server® Driver for PHP 2.0
      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 SQL Server. The drivers work with all editions of SQL Server 2005 and later, as well as SQL Azure, and rely on the Microsoft SQL Server Native Client to communicate with SQL Server. The SQL Server Native Client can be downloaded on this Feature Pack page.

      Audience(s): Developer



    Microsoft® SQL Server® Migration Assistant

Related Resources