Deploying SQL 2008 Express with Advanced Services SP1 on Windows Server 2008 R2

 

I can’t seem install MS SQL Server 2008 Express with Advanced Services natively on a Windows Server 2008 R2. Why use it? Primary its free like the SQL Express and it has advanced features like of the full SQL Server 2008 as described here: http://msdn.microsoft.com/en-us/library/ms365248.aspx

Cant install, mainly because as of this moment I have not found a downloadable copy of the MS SQL 2008 Express with Advanced Services SP1 from the Microsoft Download site. To install SQL 2008 on Windows Server 2008 R2, it must be already on SP1. I think that the only way I can install this is to do a slipstreamed copy.

Slipstream is a way of infusing the installer and its update so that the installer may already have the update in it upon install. This is very handy for mass deployment and for situations like this where it is required to have an SP1 copy to install. http://en.wikipedia.org/wiki/Slipstream_(computing)

So here is how I did it:

1. Download the installers:

SQL 2008 Express with Advanced Services installer from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SQL Server 2008 Service Pack 1 (SP1) update from here : http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

2. Merge the installers.

First you must extract the files from the SQL Express installer with the “/x” switch. In my case I put it on the root of my C:\. So to do this open your CMD prompt and type in without quotes: “en_sql_server_2008_express_with_advanced_services_x64.exe /x:c:\SQLServer2008_FullSP1”. Hit enter.

So the syntax goes <INSTALLER> /x:<PATH-TO-EXTRACT-TO>

That command extracts the installer files to the c:\SQLServer2008_FullSP1 directory.

After extraction, a message box will appear prompting us that the extract is now complete.

 

Now we extract the update and put it in the PCU directory of c:\SQLServer2008_FullSP1

Same syntax, so opening CMD and typing in: SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU. Hit enter.

It is the same thing for the updates, a prompt will appear after extraction.

 

Then we must copy the setup.exe and setup.rll from the child PCU directory to the root c:\SQLServer2008_FullSP1 directory. We can use robocopy for this:

so with the command prompt still open:

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe”

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll”

Then we must copy everything from c:\SQLServer2008_FullSP1\PCU\x64 directory to c:\SQLServer2008_FullSP1\x64 except the Microsoft.SQL.Chainer.PacakgeData.dll. To do that, simply use robocopy with this command:

“robocopy c:\SQLServer2008_FullSP1\PCU\x64 c:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PacakgeData.dll”

Please see the results if it looks like this: Note that we skipped one and copied 71 files.

We have to create now the DefaultSetup.ini file in the c:\SQLServer2008_FullSP1\x64 directory.

To do this open up your favorite text editor, mine is notepad then save it as DefaultSetup.ini. Make sure that you choose all files before saving to create the .ini extension and not have a .ini.txt file.

The DefaultSetup.ini file must contain the ff:

 

 

3. Run Setup

After the last step above, run the setup.exe in the c:\SQLServer2008_FullSP1 like nothing happend 😀

There ya go, the setup is now running without that prompt that you need to be updated ….

4. Checking

Check if you are really installing 2008 Express with Advanced Services:

After running the install process you may find that you also passed the  Update setup media language compatibility

After the setup is complete you may review the summary log of the installation by clicking the link highlighted in yellow as seen here:

 

Scroll down to the text file in notepad and look for the PCUSOURCE entry under User Input Settings.

The value must be our PCU directory under c:\SQLServer2008_FullSP1\. This verifies that our installer is already at SP1

 

There you have it, a slipstreamed install of SQL 2008 with Advanced Services SP1 ready for deployment.

RECAP: Here is the short story of the list of things and commands that we did:

 

Download the FF and copy to C:\ directory for easy access.

SQL 2008 Express with Advanced Services  http://www.microsoft.com/downloads/details.aspx?FamilyID=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SQL Server 2008 Service Pack 1 (SP1) : http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

Extract and merge the Installer with SP1 (with command prompt)

en_sql_server_2008_express_with_advanced_services_x64.exe /x:c:\SQLServer2008_FullSP1

SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe”

“robocopy c:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll”

“robocopy c:\SQLServer2008_FullSP1\PCU\x64 c:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PacakgeData.dll”

Create DefaultSetup.ini file at c:\SQLServer2008_FullSP1\x64.

; SQLSERVER2008 Configuration File

[SQLSERVER2008]

PCUSOURCE=”C:\SQLServer2008_FullSP1\PCU”

 

Run Setup.exe from C:\SQLServer2008_FullSP1\

That’s it!

Advertisements

Published by

johndelizo

John is currently creating digital assets that protects people and their future, a technical trainer and a full time geek specializing on development and deployment of innovations created with .NET framework on Windows platform as well as Windows infrastructure projects. He is the primary contact of the Philippine Windows Users Group, a contributor at the Microsoft Philippines Community forums and regularly conducts community sessions as well as other Microsoft technology events. John owns the Busy Saving The World Techblog.

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