The new Surface Pro
The most versatile laptop
SHOP NOW
Introducing Surface Laptop
Performance made personal
SHOP NOW

Microsoft® SQL Server® 2008 R2 SP2 Feature Pack

Select Language:

Choose the download that you want

File Name

Size

	PowerShellTools_x86.msi 1.8 MB	1.8 MB
	PowerShellTools_amd64.msi 2.3 MB	2.3 MB
	PowerShellTools_ia64.msi 4.0 MB	4.0 MB
	RBS_amd64.msi 5.2 MB	5.2 MB
	RBS_ia64.msi 7.6 MB	7.6 MB
	RBS_x86.msi 4.2 MB	4.2 MB
	SapBI_amd64.msi 3.0 MB	3.0 MB
	SapBI_ia64.msi 4.8 MB	4.8 MB
	SapBI_x86.msi 2.1 MB	2.1 MB
	SharedManagementObjects_amd64.msi 15.8 MB	15.8 MB
	SharedManagementObjects_ia64.msi 20.3 MB	20.3 MB
	SharedManagementObjects_x86.msi 10.6 MB	10.6 MB
	SqlCmdLnUtils_amd64.msi 12.0 MB	12.0 MB
	SqlCmdLnUtils_ia64.msi 16.3 MB	16.3 MB
	SqlCmdLnUtils_x86.msi 7.1 MB	7.1 MB
	sqlncli_amd64.msi 7.8 MB	7.8 MB
	sqlncli_ia64.msi 10.8 MB	10.8 MB
	sqlncli_x86.msi 4.5 MB	4.5 MB
	SQLSERVER2008_ASADOMD10_amd64.msi 7.0 MB	7.0 MB
	SQLSERVER2008_ASADOMD10_ia64.msi 9.4 MB	9.4 MB
	SQLSERVER2008_ASADOMD10_x86.msi 4.5 MB	4.5 MB
	SQLSERVER2008_ASAMO10_amd64.msi 4.6 MB	4.6 MB
	SQLSERVER2008_ASAMO10_ia64.msi 6.3 MB	6.3 MB
	SQLSERVER2008_ASAMO10_x86.msi 2.9 MB	2.9 MB
	SQLSERVER2008_ASOLEDB10_amd64.msi 54.6 MB	54.6 MB
	SQLSERVER2008_ASOLEDB10_ia64.msi 61.9 MB	61.9 MB
	SQLSERVER2008_ASOLEDB10_x86.msi 24.2 MB	24.2 MB
	SQLServerBestPracticesPolicies_x86.msi 1.3 MB	1.3 MB
	SQLSysClrTypes_amd64.msi 3.5 MB	3.5 MB
	SQLSysClrTypes_ia64.msi 5.4 MB	5.4 MB
	SQLSysClrTypes_x86.msi 3.4 MB	3.4 MB
	SSBEAS_amd64.msi 2.7 MB	2.7 MB
	SSBEAS_ia64.msi 4.7 MB	4.7 MB
	SSBEAS_x86.msi 2.1 MB	2.1 MB

Download Summary:

KBMBGB

You have not selected any file(s) to download.

Total Size: 0

Back Next

Microsoft recommends that you install a Download Manager.

A download manager is recommended for downloading multiple files.

Microsoft Download Manager

Manage all your internet downloads with this easy-to-use manager.It features a simple interface with many customizable options:

Download multiple files at one time
Download large files quickly and reliably
Suspend active downloads and resume downloads that have failed

Would you like to install the Microsoft Download Manager?

Yes, install Microsoft Download Manager(recommended)
No, thanks

What happens if I don't install a download manager?

Why should I install the Microsoft Download Manager?

Generally, a download manager enables downloading of large files or multiples files in one session.Many web browsers, such as Internet Explorer 9, include a download manager.Stand-alone download managers also are available, including the Microsoft Download Manager.

if you do not have a download manager installed, and still want to download the file(s) you've chosen, please note:

You may not be able to download multiple files at the same time.In this case, you will have to download the files individually.(You would have the opportunity to download individual files on the "Thank you for downloading" page after completing your download.)
Files larger than 1 GB may take much longer to download and might not download correctly.
You might not be able to pause the active downloads or resume downloads that have failed.

The Microsoft Download Manager solves these potential problems.It gives you the ability to download multiple files at one time and download large files quickly and reliably.It also allows you to suspend active downloads and resume downloads that have failed.

Microsoft Download Manager is free and available for download now.

Back Next

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

Details
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.50.4000.0
File Name:
PowerShellTools_x86.msi
PowerShellTools_amd64.msi
PowerShellTools_ia64.msi
RBS_amd64.msi
RBS_ia64.msi
RBS_x86.msi
SapBI_amd64.msi
SapBI_ia64.msi
SapBI_x86.msi
SharedManagementObjects_amd64.msi
SharedManagementObjects_ia64.msi
SharedManagementObjects_x86.msi
SqlCmdLnUtils_amd64.msi
SqlCmdLnUtils_ia64.msi
SqlCmdLnUtils_x86.msi
sqlncli_amd64.msi
sqlncli_ia64.msi
sqlncli_x86.msi
SQLSERVER2008_ASADOMD10_amd64.msi
SQLSERVER2008_ASADOMD10_ia64.msi
SQLSERVER2008_ASADOMD10_x86.msi
SQLSERVER2008_ASAMO10_amd64.msi
SQLSERVER2008_ASAMO10_ia64.msi
SQLSERVER2008_ASAMO10_x86.msi
SQLSERVER2008_ASOLEDB10_amd64.msi
SQLSERVER2008_ASOLEDB10_ia64.msi
SQLSERVER2008_ASOLEDB10_x86.msi
SQLServerBestPracticesPolicies_x86.msi
SQLSysClrTypes_amd64.msi
SQLSysClrTypes_ia64.msi
SQLSysClrTypes_x86.msi
SSBEAS_amd64.msi
SSBEAS_ia64.msi
SSBEAS_x86.msi
Date Published:
26/07/2012
File Size:
1.8 MB
2.3 MB
4.0 MB
5.2 MB
7.6 MB
4.2 MB
3.0 MB
4.8 MB
2.1 MB
15.8 MB
20.3 MB
10.6 MB
12.0 MB
16.3 MB
7.1 MB
7.8 MB
10.8 MB
4.5 MB
7.0 MB
9.4 MB
4.5 MB
4.6 MB
6.3 MB
2.9 MB
54.6 MB
61.9 MB
24.2 MB
1.3 MB
3.5 MB
5.4 MB
3.4 MB
2.7 MB
4.7 MB
2.1 MB
+ More - Less

KB Articles: KB2630458

The Microsoft® SQL Server® 2008 R2 SP2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. The packages provided include the latest versions of:

Redistributable components for Microsoft® SQL Server® 2008 R2 SP2

Add-on providers for Microsoft® SQL Server® 2008 R2 SP2

Note: Some components in the Microsoft® SQL Server® 2008 R2 SP2 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.

Each item in Instructions section describes a short description of the package.
The audience(s) for which it was intended is 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.
System Requirements
Supported Operating System
Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP
Note: System requirements for each Feature Pack is dependant on required technologies. When redistributing a Feature Pack, please refrain from renaming package filenames as there could unexpected failures during installation, update, or removal for the package.
Install Instructions
Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 SP2
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 SP2.

Learn more and Download SQL Server Report Builder 3.0 for Microsoft SQL Server 2008 R2 SP2

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

Learn more and Download Reporting Services Add-in for Microsoft® SharePoint Technologies 2010

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

Learn more and Download Reporting Services Add-in for Microsoft Sharepoint Technologies 2007

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

Learn More and Download Power Pivot for Microsoft Excel

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

Download SapBI.msi package (Available for X86, X64 and IA64 architecture.)

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

Download SQLSysClrTypes.msi package (Available for X86, X64 and IA64 architecture.)

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

Download RBS.msi package (Available for X86, X64 and IA64 architecture.)

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

Download sqlncli.msi package (Available for X86, X64 and IA64 architecture.)

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

Download SqlCmdLnUtils.msi package (Available for X86, X64 and IA64 architecture.)

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

Download SSBEAS.msi package (Available for X86, X64 and IA64 architecture.)

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, available on SQL Server 2008 R2 SP2 Express page. This component also requires Windows PowerShell 1.0; download instructions are on the Windows Server 2003 Web site.

Audience(s): Customer, Partner, Developer

Download PowerShellTools.msi package (Available for X86, X64 and IA64 architecture.)

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.

Audience(s): Customer, Partner, Developer

Download SharedManagementObjects.msi package (Available for X86, X64 and IA64 architecture.)

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

Download SQLSERVER2008_ASADOMD10.msi package (Available for X86, X64 and IA64 architecture.)

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.

Audience(s): Customer, Partner, Developer

Download SQLServer2008_ASOLEDB10.msi package (Available for X86, X64 and IA64 architecture.)

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

Download SQLSERVER2008_ASAMO10.msi package (Available for X86, X64 and IA64 architecture.)
Related Resources
SQL Server 2008 R2 SP2

SQL Server 2008 R2 SP2 Express

KnowledgeBase article for SQL Server 2008 R2 SP2

Hardware and Software for SQL Server 2008 R2

The new Surface Pro

Introducing Surface Laptop

Microsoft® SQL Server® 2008 R2 SP2 Feature Pack

Choose the download that you want

Microsoft recommends that you install a Download Manager.

Microsoft Download Manager