SQL Server 2008 SP2 Released!

SQL Server 2008 SP2 Released!

Rate This
  • Comments 4

Dear Customer,

Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.  Service Pack 2 for SQL Server 2008 includes new compatibility features with SQL Server 2008 R2, product improvements based on requests from the SQL Server community, and hotfix solutions provided in SQL Server 2008 SP1 Cumulative Update 1 to 8.

Key enhancement in Microsoft SQL Server 2008 Service Pack 2 are:

  • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products.   SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. This now enables SharePoint Server 2007 to be used with SQL Server 2008 R2 Report Server. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What's New (Reporting Services).

  • SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
    • SQL Server 2008 Instance Management With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. SQL Server 2008 SP2 enables organizations to extend the value of the Utility Control Point to instances of SQL Server 2008 SP2 without having to upgrade those servers to SQL Server 2008 R2. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.
    • Data-tier Application (DAC) Support. Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications. 

To download the SQL Server 2008 SP2 release please select from the links below:

 Thanks to all the customers who downloaded Microsoft SQL Server 2008 SP2 CTP and provided feedback.

 Abhishek Sinha
Program Manager
SQL Server Sustained Engineering



Related Downloads & Documents:

Leave a Comment
  • Please add 1 and 1 and type the answer here:
  • Post
  • It includes CU 1 through 8? What about 9 (support.microsoft.com/.../2083921)?

  • Presumably CU9 & 10 were too late in the testing cycle to be included in the service pack.  At a guess CU1 for SP2 will include the changes that were made in CU9 & 10.

  • Which components of the feature packs have been updated?  It is painful downloading them all again on the off-chance.

    Also, this was announced by e-mail as a service pack for R2 - this is in error, correct?  And does this mean that there are no feature packs for R2?  It all seems rather vague.

  • If I am running SQL 2008 SP1 and am mounting and recovering to a mount host running the same.

    Can I upgrade the target host to SP2 and leave Prod at SP1 and still expect Recovery to work?

Page 1 of 1 (4 items)