Is it possible to install Microsoft SQL Server 2008 Express without requiring a reboot? I'm trying to install IBM Sterling Connect:Direct for Windows with Microsoft SQL Server 2008 Express as the database, but this causes the machine to reboot.
If you are prompted for a reboot, then Windows has a need for it. Simple as that.
MSSQL comes with a rich set of requirements that need to be installed and activated before the actual MSSQL setup can start. One of them is likely triggering the reboot here, maybe because files are in use and cannot be updated.
Install using a batch command coded like:
"SQLEXPRWT_x86_ENU.exe /QS /Hideconsole /ACTION=Install /FEATURES=SQLEngine
/INSTANCENAME=CDWINDOWS /SQLSVCACCOUNT="NT AUTHORITY\Network Service"
/SQLSVCStartupType=Automatic /AddCurrentUserAsSqlAdmin /ENABLERANU=1
Placed in the same directory as install program "SQLEXPRWT_X86_EN.exe" will do the trick, BUT if you are prompted for a reboot, then Windows has a need for it. Simple as that.
The trick is to install all pre-requisites before starting the MSSQL setup. If you do not let Windows perform the installation fully automatically, then you must make absolutely sure that all the pre-requisites are there before you start.