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

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

• Redistributable components for SQL Server 2008.
• Add-on providers for SQL Server 2008.
• Backward compatibility components for SQL Server 2008.

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 May 2012.

No files found

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.

Supported operating systems: Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista Service Pack 1, 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 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.

Building on the value delivered in Report Builder 2.0, the November CTP of Report Builder 3.0 introduces new support for geospatial visualization (mapping, routing, custom shapes) which can help produce new insights and discoveries well beyond what can be achieved with standard tables and charts when geospatial data is combined with business information. 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.


Download site

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

This 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. New capabilities delivered include:

• Multizone support. Use the alternate access mapping functionality in your SharePoint environment to access report server items from one or more SharePoint zones (default, internet, intranet, extranet, or custom). This is useful when you have a SharePoint environment that can be accessed by users from multiple zones


• SharePoint list support. Access SharePoint lists as data sources for building reports in Report Builder


• Ribbon user experience. Group reports in a more logical manner through the extension of the SharePoint ribbon, making content much easier to find


Audience(s): Customer, Partner, Developer


Download site

Microsoft SQL Server 2008 Reporting Services November CTP 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


Download site

SQL Server Compact 3.5 SP2 Beta 2 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 SP2 Beta 2 on Windows desktop.

Audience(s): Customer, Partner, Developer


Download site

SQL Server Compact 3.5 SP2 Beta 2 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 SP2 Beta 2 on Windows desktop.

Audience(s): Customer, Partner, Developer


Download site

In its continued commitment to interoperability, Microsoft has released a Java Database Connectivity (JDBC) driver for SQL Server. 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 2000, SQL Server 2005, SQL Server 2008, and SQL Server 2008R2 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


Download site

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


X86 Package(SQLSysClrTypes_x86.msi) – 3,342 KB
X64 Package (SQLSysClrTypes._x64msi) – 3,459 KB
IA64 Package(SQLSysClrTypes_ia64.msi) – 5,352 KB

SQL Server System CLR Types 2008 R2 Books on-line page

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


X86 Package (RBS_x86.msi) – 3,690 KB
X64 Package (RBS_x64.msi) – 4,764 KB
IA64 Package (RBS_ia64.msi) – 7,178 KB

SQL RBS codeplex samples page


RBS blogs

Microsoft SQL Server 2008 R2 Books Online is the primary documentation for SQL Server. Download a pre-release preview of Books Online for SQL Server 2008 R2. If you were looking for the latest released version of Books Online, visit the SQL Server 2008 Books Online page on the Microsoft Download Center.

Important Installing SQL Server 2008 R2 Books Online upgrades your existing SQL Server 2008 version of Books Online. If you upgrade, be aware that the content and help topics now describe tools and features of SQL Server 2008 R2. To reinstall SQL Server 2008 Books Online, you must first uninstall SQL Server 2008 R2 Books Online. Because SQL Server 2008 and SQL Server 2008 R2 share components, you cannot have side-by-side installations of Books Online on the same machine.

Note This pre-release version of SQL Server Books Online may contain topics that are empty, incomplete, or not up to date. Topics for new features may be missing and not all new or updated content has been reviewed for technical accuracy.

Books Online includes the following types of information:

• Setup and upgrade instructions.


• Information about new features and backward compatibility.


• Conceptual descriptions of the technologies and features in SQL Server.


• Procedural topics describing how to use the various features in SQL Server.


• Tutorials that guide you through common tasks.


• Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server.


• Descriptions of the sample databases and applications that are available with SQL Server.




Audience(s): Developer, DBA


Download site

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 (RBS_x86.msi) – 3,690 KB
X64 Package (RBS_x64.msi) – 4,764 KB
IA64 Package (RBS_ia64.msi) – 7,178 KB

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) - 4549 KB
X64 Package (sqlncli.msi) - 7963 KB
IA64 Package (sqlncli.msi) - 11112 KB

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


Download site

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 Distributed Query 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


Package (DB2OLEDB.exe) - 44607 KB

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 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) - 7234 KB
X64 Package (SqlCmdLnUtils.msi) - 12212 KB
IA64 Package(SqlCmdLnUtils.msi) - 16515 KB

The Microsoft SQL Sql Server 2008 R2 Service Broker External Activator is distributed in the Microsoft SQL Server 2008 R2 Feature Pack. It is an extension of the Internal Activation feature in SQL Server 2008 R2 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


X86 Package(SSBEAS.msi) - 2057 KB
X64 Package (SSBEAS.msi) - 2620 KB
IA64 Package(SSBEAS.msi) - 4716 KB

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 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) - 4549 KB
X64 Package (PowerShellTools.msi) - 7963 KB
IA64 Package (PowerShellTools.msi) - 11112 KB

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 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) - 3225 KB
X64 Package (SharedManagementObjects.msi) - 3895 KB
IA64 Package (SharedManagementObjects.msi) - 5640 KB

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

Audience(s): Customer, Partner, Developer


X86 Package(SQLSERVER2008_ASADOMD10.msi) - 4312 KB
X64 Package (SQLSERVER2008_ASADOMD10.msi) - 9263 KB
IA64 Package(SQLSERVER2008_ASADOMD10.msi) - 6776 KB

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) - 19490 KB
X64 Package (SQLServer2008_ASOLEDB10.msi) - 43945 KB
IA64 Package(SQLServer2008_ASOLEDB10.msi) - 50682 KB

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) - 2659 KB
X64 Package (SQLSERVER2008_ASAMO10.msi) - 4317 KB
IA64 Package(SQLSERVER2008_ASAMO10.msi) - 6055 KB