Servers

    Microsoft SQL Server 2008 Service Pack 2 Feature Pack

    Select Language:
    Download the Microsoft SQL Server 2008 SP2 Feature Pack, a collection os stand-alone install packages that provide additional value for SQL Server 2008 SP2.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      10.00.4000.00

      File Name:

      SSBEAS.msi

      PowerShellTools.msi

      RBS.msi

      SapBI.msi

      SharedManagementObjects.msi

      sql_rmo.msi

      SqlCmdLnUtils.msi

      sqlncli.msi

      SQLServer2005_BC.msi

      SQLSERVER2008_ASADOMD10.msi

      SQLSERVER2008_ASAMO10.msi

      SQLSERVER2008_ASOLEDB10.msi

      SQLServer2008_DMViewer.msi

      SQLServerBestPracticesPolicies.msi

      SQLSysClrTypes.msi

      sqlxml.msi

      Synchronization.msi

      SyncServicesADO.msi

      Date Published:

      9/29/2010

      File Size:

      2.1 MB

      1.7 MB

      3.4 MB

      2.0 MB

      10.0 MB

      8.9 MB

      6.9 MB

      4.4 MB

      11.0 MB

      4.3 MB

      2.7 MB

      18.9 MB

      9.2 MB

      1.3 MB

      1.5 MB

      7.1 MB

      2.7 MB

      1.0 MB

      KB Articles: KB2285068

        The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008 SP2.
    • Supported Operating System

      Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP Service Pack 3


        Supported Operating Systems: Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP; Windows XP Service Pack 3
        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.
        • Download the appropriate file by clicking one of the links below, then run the downloaded file to install thSat package.
          Each package indicates the audience(s) for which it was intended, as follows:
            Customer: An individual may want to install this for additional licensed functionality such as interoperability.
            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 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 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 languages.

            Audience(s): Customer, Partner, Developer



          Microsoft 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



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

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server 2005 Backward Compatibility Components
            The SQL Server Backward Compatibility package includes the latest versions of the Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 Service Pack 4 (SP4) and SQL Server 2005 SP2.

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server 2008 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 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 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



          SQL Server Compact 3.5 SP1
            SQL Server Compact is a free, easy-to-use embedded database engine that lets developers build robust Microsoft Windows desktop and mobile applications that run on all Windows operating systems including Windows XP, Vista, Pocket PC, and Smartphone. Run the Microsoft Windows installer file (MSI) to install the product. The single setup program will install the provider and tools on x86 and x64 computers. The package includes product updates in the form of an integrated Service Pack 1. Read the installation guide and Readme for more information.

            Audience(s): Customer, Partner, Developer



          Microsoft Connector 1.0 for SAP BI
            The Microsoft Connector for SAP BI is a set of managed components for transferring data to or from an SAP NetWeaver BI version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 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): Customer, Developer



          Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007
            Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 enables you to take advantage of SQL Server 2008 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:
            • Table Analysis Tools for Excel: This add-in provides easy-to-use tools that leverage SQL Server 2008 data mining features to perform powerful analytics on your spreadsheet data. Two new tools have been added for this release: Prediction Calculator and Shopping Basket Analysis.
            • Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel 2007 using your spreadsheet data or external data accessible through your SQL Server 2008 Analysis Services instance. This release adds support for new SQL Server 2008 data mining features including holdout and cross-validation, a new Document Model wizard, and improvements to existing wizards.
            • Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2007 drawings.


            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server 2008 Datamining Viewer Controls
            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.

            Note:Microsoft SQL Server 2008 Datamining Viewer Controls requires Microsoft ADOMD.NET, also available on this page.

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server Driver for PHP 1.0
            The SQL Server Driver for PHP 1.0 is a PHP 5 extension that allows for accessing data in all Editions of SQL Server 2005 and SQL Server 2008 (including Express Editions) from within PHP scripts. The driver provides a procedural interface for accessing data and makes use of PHP features, including PHP streams to read and write large objects. With this release, the source code for the driver is available here: http://go.microsoft.com/fwlink/?LinkID=123842. The SQL Server Driver for PHP 1.0 relies on the Microsoft SQL Server 2005 Native Client to communicate with SQL Server. For more information about SQL Server 2005 Native Client, visit the SQL Server Native Client page on MSDN.

            Audience(s): Developer, DBA



          Microsoft Core XML Services (MSXML) 6.0
            Microsoft Core XML Services (MSXML) 6.0 is 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 SQL Server 2005 JDBC Driver 1.2
            In its continued commitment to interoperability, Microsoft has released a Java Database Connectivity (JDBC) driver for SQL Server. The SQL Server 2005 JDBC Driver v1.2 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 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 J2EE (Java2 Enterprise Edition).

            Audience(s): Partner, Developer



          Microsoft SQL Server 2008 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 and SQL Server 2008.
            Note: Microsoft SQL Server 2008 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



          Microsoft OLEDB Provider for DB2
            The Microsoft OLE DB Provider for DB2 version 2.0 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the version 2.0 provider and tools on x86, x64, and IA64 computers. Read the installation guide and Readme for more information.

            Audience(s): Customer, Developer

              Package (DB2OLEDB.exe) - 45893 KB


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



          Microsoft SQL Server 2008 Policies
            Microsoft SQL Server 2008 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 Books Online.

            Note: This component also requires Windows Installer 4.5.

            Audience(s): Customer, Partner, Developer

              Package (SQLServerBestPracticesPolicies.msi) - 1281 KB


          Microsoft Windows PowerShell Extensions for SQL Server
            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 requires SQL Server 2008 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



          Microsoft SQL Server 2008 Replication Management Objects
            The Microsoft SQL Server 2008 Replication Management Objects package includes API for managing SQL Server 2008 replication objects programmatically. The Replication Management Objects package requires Windows Installer 4.5, Microsoft SQL Server Native Client 10.0, and the SQL Server 2008 Management Objects (SMO) Collection package.

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server 2008 Report Builder 2.0
            Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users with a Microsoft Office look and feel. Report Builder 2.0 supports the full capabilities of Report Definition Language (RDL) including flexible data layout, data visualizations, and richly formatted text features of SQL Server 2008 Reporting Services. The download provides a stand-alone installer for Report Builder 2.0.

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

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
            Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes data-driven subscriptions. The download provides a Report Viewer Web part, Web application pages, and support for using standard Windows SharePoint Services or Microsoft Office SharePoint Services.

            Audience(s): Customer, Partner, Developer



          Microsoft SQL Service Broker External Activator
            The Microsoft SQL Service Broker External Activator is distributed in the Microsoft SQL Server 2008 Feature Pack. It is an extension of the Internal Activation feature in SQL Server 2008 and lets you move the logic for receiving and processing Service Broker messages from the Database Engine service to an application executable that runs outside the Database Engine service. This can provide a higher level of scale-out performance by moving processing loads from the database server to another computer. The activation application process can also run under a different Windows account from the Database Engine process. This gives administrators additional control over the resources that the activation application can access. Run the self-extracting download package to create an installation folder. The single setup program will install the service on x86, x64, and IA64 computers. Read the documentation for more information.

            Audience(s): Customer, Developer



          Microsoft SQL Server System CLR Types
            The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types in SQL Server 2008. 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 SQLXML 4.0 SP1
            SQLXML enables XML support for your SQL Server Database. It allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file. SQLXML allows you to:
            • Query relational database with XPath
            • Update relational data as if it was XML
            • Load XML into SQL Server
            • Query SQL Server OLEDB/ADO or .NET Framework Managed Classes
            Microsoft SQLXML 4.0 SP1 provides support for new SQL Server 2008 data types such as Date, Time, DateTime2 and DateTimeOffset.

            Audience(s): Customer, Partner, Developer



          Microsoft Sync Framework
            Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. Using the Microsoft Sync Framework runtime, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network. Sync Services for ADO.NET is a part of the Microsoft Sync Framework. Sync Services for ADO.NET enables synchronization between ADO.NET enabled databases. Because Sync Services for ADO.NET is part of the Microsoft Sync Framework, any database that uses Sync Services for ADO.NET can then also exchange information with other data sources that are supported by Microsoft Sync Framework, such as web services, file systems or custom data stores. For more information about the Microsoft Sync Framework, please go to Microsoft Sync Framework Developer Center.

            Audience(s): Customer, Developer



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

            Note: This component also requires Windows Installer 4.5.

            Audience(s): Customer, Partner, Developer

      • If you have questions about Feature Pack content, visit the SQL Server forums on MSDN.

        Visit the Microsoft Connect site to:
        • Access more resources, including white papers, training, and webcasts.
        • Receive information about future downloads, alerts, newsletters, and more.
        • Help improve SQL Server 2008 by submitting feedback.
        • Participate in forum discussions.

        Download the SQL Server 2008 Books Online

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial