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)
For the detailed how to go to this link that also has screenshots and explanations on the steps done:
Deploying SQL 2008 Express with Advanced Services SP1 on Windows Server 2008 R2
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!