Microsoft SQL Server 2008 Service Pack 4 Feature Pack

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008 SP4.

Supported Operating Systems

Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Vista

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:

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.


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



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.


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



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.


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



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


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



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.


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



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.


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



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.


X86 Package (RBS.msi)
X64 Package (RBS.msi)



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.


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



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.


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



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 or x64 computers. Read the documentation for more information.


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



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.


X86 Package(SQLSysClrTypes.msi)
X64 Package (SQLSysClrTypes.msi)

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