Technote (FAQ)
Question
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.
Cause
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.
Answer
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
/SKIPRULES=RebootRequiredCheck"
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.