This is a set of dependency modules for Setup Factory, and it can be used if you need to deploy SQL Server 2008 R2 Express Edition (32 or 64 bit) on your client's computer.
SQL Server 2008 R2 needs the .NET 3.5 Framework SP1, as well as Windows Installer 4.5. These modules are already shipping with Setup Factory 9, however some changes have been made to the installation scripts, so they work better in the installation procedure of SQL Server 2008 R2. All three installers can be run in passive mode, rebooting the computer when needed. For example, if no reboot was performed on a 32-bit platform after Windows Installer 4.5 was just successfully installed, the installation of SQL Server 2008 R2 will fail with error codes like "2227047362". The new dependency modules for .NET 3.5 Framework SP1 and Windows Installer 4.5 make sure that the whole installation is performed as smooth as possible.
How to use
- Download the installer below and select the desired packages for installation.
The installer will detect if you have the required runtime modules for the dependencies you selected to deploy. If there are files missing on your system, these will be automatically selected for download.
- The SQL Server 2008 R2 Express Edition dependency module comes in three versions: 32-bit only, 64-bit only, and a third dependency for both platforms, where the proper runtime will be executed according to the platform that was detected. SQL Server 2008 R2 also needs Windows Installer 4.5 and the .NET 3.5 Framework SP1, so you must make sure that these are included before attempting to deploy SQL Server. Failing to do so will cause numeric error messages.
- It appears to be safer to deploy Windows Installer 4.5 is before the .NET 3.5 Framework SP1, however it is best if you perform your own tests.
- In the .NET 3.5 SP1 dependency installation script, make sure that you set these variables as shown or make changes to your script, especially if you chose not replacing it with the new web installer:
local _NeedsReboot = false; local bSilentMode = true; local bVital = true;
- In the Windows Installer 4.5 dependency installation script, make sure that you set these variables as shown, especially if you chose not replacing it with the updated version:
local bVital = true; local bSilentMode = true; local bNoRestart = true;
- In the SQL Server 2008 R2 Express Edition dependency installation script, make sure that you set these variables:
local SQLSVCACCOUNT = "NT AUTHORITY\\Network Service"; local SQLSVCPASSWORD = 'StrongPassword';
The variables SQLSVCACCOUNT and SQLSVCPASSWORD should be set to reflect the desired user account and the sa password under which SQL Server 2008 R2 will be running. Of course you can modify the command line used for the installation of the product, if you do not wish to use a single setting for SQLSVCACCOUNT, SQLSYSADMINACCOUNTS and AGTSVCACCOUNT.
Feel free to modify the detection/installation scripts further, if you need or wish to. For example, you may want to change the module to deploy the "Database with Management Tools" or "Database with Advanced Services" packages, instead of the "Database Only" installer that is included here. You have to know how you would need to update the command line arguments passed to these installers, however - I cannot offer assistance on this matter. As usual, feedback and thanks is always appreciated - please use the comment box below.
You can find the dependency module for SQL Server 2008 R2 Express Edition for MSI Factory here.
Don't have Setup Factory?
If you want to purchase a license for Setup Factory 9, now is a good time! For a limited period, you can get 10% off the list price simply by clicking the banner below:
Do you find this useful?
Several hours of work were invested into software offered here free of charge. If my efforts make your tasks easier and saved you hours of research and coding, please consider making a small donation as a sign of appreciation of my work.