Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

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
Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services. This download provides a 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.

image image
image image
image image
image image
image image
image  

 

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?

image

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 info@magenic.com 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:

EnjoyOpen-mouthed

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: