I am trying to figure out the code to install SQL Server 2008 Express Engine from the command line as part of my installation package. We previously used SQL Server 2005 Express Engine (upgrading the tool set), but SQL Server 2008 Express Engine installer has more required options (or, so it appears to). The following does not work. However, it processes for a while before it abruptly stops. the screen disappears, and I have no idea what the problem is. How do I create a log, and what is wrong with the below command line entry? Thanks for any help.
SQLEXPR_x86_ENU.exe /qs /ACTION=Install /BROWSERSVCSTARTUPTYPE=Automatic /SQLSVCSTARTUPTYPE=Automatic /FEATURES=SQL /INSTANCENAME=MYDB /SAPWD="SQL2008UpgradePassword" /SQLSYSADMINACCOUNTS="sa" /SECURITYMODE="SQL" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /ISSVCACCOUNT="NT AUTHORITY\Local Service" /RSSVCACCOUNT="NT AUTHORITY\Local Service"
The below previous version for SQL Server 2005 Express worked just fine, but I'm not sure how to get it working for 2008.
sqlexpr.exe /qb INSTANCENAME=TPSDB ASACCOUNT="sa" SAPWD="SQL2005UpgradePassword" ADDLOCAL=SQL_Engine,SQL_Data_Files SQLAUTOSTART=1 SECURITYMODE=SQL