1. Load the setup for SQL2008EE with Advanced Services from Microsoft webpage.
2. Extract all files to a temporary Folder (using 7zip)
3. Make a backup copy the file mediainfo.xml in this folder
4. Load the setup for SQL2008EE SP1 (without Advanced Services)
5. Start the setup loaded in step 3, but do not continue when the welcome screen appears.
6. The files in the setup are being extracted to a temporary folder in your boot drive. The folder name is a GUID.
7. Locate this folder and copy all files over the existing files in the temporary folder created in step 2.
8. Restore the mediainfo.xml from the backup created in step 3
This setup works fine and installs SQL-Server 2008 Express Edition SP1 with Advanced Services. The following commandline for Setup.exe installs SQL-Server (including Fulltext and Replication), ReportingServices, Managementstudio and Business Intelligence Development Studio. TCP/IP-Protocol is also enabled:
/Q /ACTION=INSTALL /SECURITYMODE=SQL /SAPWD=$SQLPASSWORD$ /INSTANCENAME=$INSTANCENAME$ /FEATURES=SQL,RS,TOOLS /SQLSVCACCOUNT="NT AUTHORITY\\NETWORK SERVICE" /RSSVCACCOUNT="NT AUTHORITY\\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="$SQL_COMPUTER_NAME$\\$SQL_USER_NAME$" /TCPENABLED=1
(Of course you have to provide values for the variables $SQLPASSWORD$, $INSTANCENAME$, $SQL_COMPUTER_NAME$, $SQL_USER_NAME$)
The description of the parameters can be found here:
ttp://msdn.microsoft.com/de-de/library/ms144259.aspx#Accounts
The setup of this version of SQL-Server requires PowerShell 1.0 as a pre-requisite, so I've written separate scripts to check/install it. I can provide these scripts if you are interested.
Until now everything worked as expected, so I continued with the following:
9. Compress the content of this folder to expressx.7zip
10. Replace the original expressx.7zip in Plug-Ins\\MS SQL Express
Then I changed the command line of the SQL Server Express PlugIn manually to /SECURITYMODE=SQL /SAPWD=$SQLPASSWORD$ /INSTANCENAME=$INSTANCENAME$ /FEATURES=SQL,RS,TOOLS /SQLSVCACCOUNT="NT AUTHORITY\\NETWORK SERVICE" /RSSVCACCOUNT="NT AUTHORITY\\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="$SQL_COMPUTER_NAME$\\$SQL_USER_NAME$"
Result: Setup of SQL-Server failed
Then I've put the expressx.7zip in a file bag, extraced it during the runtime of the setup and installed SQL-Server using the Run Program command with the above mentioned command line for setup. Everything worked perfect.
The only disadvantage of this approach is, that I get no progress messages from the SQL-Server setup. The setup really takes some time, so I expect some of my users will quit setup, because it seems to "hang".
My question is: what does the Install SQL Express PlugIn do internally? Why does the setup fail with this new expressx.7zip. What commands does it add to the command line you can see if you doubleclick that command in MSIcode view?
Or: how can I run the setup and still get the PROGRESSTEXT displayed?
Thanks in advance for any help!
