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!