Error: 0x84C40007 — SQL Server 2008 Service Pack 2 installation fails on a computer with Microsoft .NET Framework 4 Client Profile already installed

Just over a week ago Service Pack 2 for SQL Server 2008 was published to Microsoft Update as an optional update. We have been notified that customers are hitting error 0x84C40007 when the Microsoft .NET Frameworks 4 Client Profile is already installed. Below is information on this issue.   Description: This error occurs when installing…


Creating a merged (slipstream) drop containing SQL Server 2008 RTM and Service Pack 2

With the release of SQL Server 2008 Service Pack 2, I am revising my instructions on how to create a slipstream drop containing the original release and Service Pack 2. These instructions are for English SQL Server but will work with any language of SQL Server if you obtain the correct service package language. 1….


Want to speed up the SQL Server Setup Installation Wizard

In SQL Server 2008 R2, we added the command line parameter /UIMODE=AutoAdvance. The official documentation is at If you add this command line parameter when running SQL Server Setup.exe, all non-essential dialogs will be skipped.    Note: Due to a known bug, it is also necessary to specify the Action or Scenario, such as…


How to slipstream SQL Server 2008 R2 and a Cumulative Update (CU)

Now that CUs are beginning to ship for SQL Server 2008 R2, I figured I needed to send out updated slipstream instructions for SQL Server 2008 R2. Since the original release of SQL Server 2008 R2 knows how to slipstream, the instructions are easier.  There are 2 different ways to slipstream. The first way, let’s…


I’m heading to TechEd in New Orleans for TechEd 2010

If you will be there and have feedback on SQL Server Setup come by and see me.  I will be answering questions around upgrade at the Database Platform (DAT) Track.


The new SQL Server Setup Portal is live on TechNet

Check it out:   This is just the initial phase of a solution-based portal page to help you discover useful Setup content. The content will continue to evolve.


Installing SQL Server 2008 R2 Express

The final release of SQL Server 2008 R2 was made publically available on April 21, 2010! SQL Server Express continues to ship in 4 different packages. In this release of Express, we simplified the installation wizard. For the November CTP release, I documented the Express installation process at The installation process has not changed…


SQL Server Support on Windows XP x64

Recently, I have been getting several questions regarding whether SQL Server 2008 or SQL Server 2008 R2 is support on Windows XP x64. The simple answer is yes.  The confusion comes in around the service packs for Windows XP x64. If you search the internet for Windows XP x64 information, you will see several references…


Slipstream SQL Server 2008 Express with Advanced Services and Service Pack 1

Several folks have recently been asking how to slipstream Express with Advanced Services and Service Pack 1. Here are the instructions. Let me know if you encounter any issues.   1. Download “Microsoft® SQL Server® 2008 Express with Advanced Services ” from x86 or x64.   2. Download the SQL Server 2008 Service Pack 1…


Install SQL Server 2008 R2 on a Multilingual User Interface (MUI) system

Just like SQL Server 2008, you can install SQL Server 2008 R2 on a MUI system. Additional checks have been added to SQL Server 2008 R2 to ensure you don’t install on an unsupported localized or MUI system. Therefore it is important you properly configure your system prior to the installation.   Here is the…