SQL Server 2008 SP1 Available and Install Experience – build 2531
Posted by denglishbi on April 9, 2009
The RTM service pack 1 (SP1) for SQL Server 2008 came out Tuesday night. With the SP1 release there is a new SQL Server 2008 Feature Pack list and a new version of Report Builder 2.0 available also. Not much has changed on the SQL Server SP1 install and you can check my previous posting about that experience, Report Builder 2.0 ClickOnce and SQL Server 2008 CTP SP1 Experience. Here is a complete list of the SP1 links:
|SQL Server 2008 Service Pack 1||You now have the ability to uninstall the service pack too if needed. Includes Report Builder 2.0 ClickOnce setup for Reporting Services (refer to my link above)|
|Microsoft SQL Server 2008 Release Notes|
|Microsoft SQL Server 2008 Readme|
|Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1||You can slipstream SP1 into the initial installation for SQL Server 2008|
|Microsoft SQL Server 2008 Feature Pack, April 2009|
|Microsoft SQL Server 2008 Upgrade Advisor, April 2009|
|Microsoft SQL Server 2008 Reporting Services Report Builder 2.0, April 2009||stand-alone installation (msi file) and allows for in-place upgrade.|
|Microsoft® SQL Server® 2008 Express Edition Service Pack 1|
|Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies, April 2009||
Report Builder 2.0 ClickOnce update for the RS SharePoint add-in
Allows for in-place upgrade.
|Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007, April 2009||
Note: If you have an earlier version of the Data Mining Add-ins installed, you must remove it using Add/Remove Programs in Control Panel before installing the latest version. User settings, such as Connections, will not be removed.
What’s New in Service Pack 1
The following features are new in Service Pack 1:
- Slipstreaming is an installation method that integrates the base installation files for a program with its service packs and enables them to be installed in a single step. You can slipstream a SQL Server 2008 update and the original installation media so that original media and the update are installed at the same time. The update setup documentation available from the Download Center has the most recent description of the slipstream process. The update setup documentation is also available at MSDN.
- You can uninstall SQL Server 2008 cumulative updates or service packs from Programs and Features in Control Panel. For more information, see "Overview of SQL Server Servicing Installation" in the update help file.
- SQL Server 2008 Service Pack 1 provides a ClickOnce version of Report Builder 2.0. Report Builder is available for use in Reporting Services (SSRS) installed in native or SharePoint integrated mode. If SSRS is installed in SharePoint integrated mode, you need to install the add-in, Microsoft SQL Server 2008 Report Builder 2.0 ClickOnce for SharePoint, to make Report Builder 2.0 ClickOnce available from a SharePoint site. For more information, see the Report Builder 2.0 ClickOnce for SharePoint Readme.
Here is my install experience for updating my Report Builder 2.0 stand-alone installation and you can see that it goes from the RTM build 1600 to SP1 build 2531.
There is a fairly critical fix for Report Model Query Designer too – FIX: The aggregate value is incorrect when you design a query that contains some entity groups by using the Report Model Query Designer in SQL Server 2008 or in SQL Server 2005.
If you are using SQL Server 2008 Maintenance plans and do not have SSIS installed on the server you will need to have CU3 or higher installed to be able to schedule and run the jobs, FIX: Error message when you run a maintenance plan in SQL Server 2008: "The SQL Server Execute Package Utility requires Integration Services to be installed".
We can also see that the issue with SQL Server Management Studio hasn’t been resolved yet either – SQL Server 2008 Management Studio (SSMS) displaying incorrect build number?
So if you have SQL Server 2008 installed I would highly recommend upgrading to SP1. If you are thinking about upgrading or are planning on it contact me and we can work on getting this going or contact Magenic at firstname.lastname@example.org and we can get something setup to make this a smooth process.
One thing to be aware of if you are planning on going with Windows Server 2008, which should be fixed next month, is the following – Windows Server 2008 Kerberos Bug – Transport Connection Issues with SSAS data and Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems.
Here are a couple of additional resources that you can check out for some additional SQL Server 2008 information:
- What’s New in SQL Server 2008 – Top New Features
- What’s New (SQL Server 2008)
- SQL Server 2008 Upgrade Technical Reference Guide – This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.