Thursday, February 16, 2012

Can't install SQL Server Express 2005 in quiet mode

I'm trying to use a bootstrapper with SQL Server Express 2005, but I'm having difficulty with the installation. I'm using the command line:
SQLEXPR.EXE /qb INSTANCENAME=myInstanceName SAPWD=mySaPassword

and it seems to fail right at the system configuration check. One of the log files says "Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0"

I can post the contents of the log files if anyone needs them.Try this. Please also check the file template.ini located at the same directory for setup.exe. You can find sample command line to install SQL Server 2005 in silent mode.

start /wait setup.exe /qb ADDLOCAL=SQL_Engine INSTANCENAME="OneExpress" SQLACCOUNT="<domain\user>" SQLPASSWORD="<strong password>" SQLBROWSERACCOUNT="<domain\user>" SQLBROWSERPASSWORD="<strong password>" SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1|||The following command line installs SQL Server Express 2005 in quiet mode (without any user input):

SQLEXPR.EXE /qb ADDLOCAL=ALL INSTANCENAME=myInstanceName SAPWD=mySaPassword

As you can see, the original command line I was having problems with did not include the "ADDLOCAL=ALL" option.

No comments:

Post a Comment