SQL 2008 Express install via command line

[SaberRider]

Hi there,

I tried to install a SQL 2008 Express Server previous to the main installer via the redistrutables of Installshield 2010 Pro.

In the Prerequisite Editor, I entered the following command for the commandline:

/qs ADDLOCAL=SQL INSTANCENAME=HUHU1337 SAPWD=test123 SQLAUTOSTART=1 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

Using this commandline, I receive an error after the SQL Server installation process which only says "Installation failed".

I just want to install the SQL Server for our application, if no other SQL 2005 or SQL 2008 Server is installed.

Is it that difficult doing this, using IS ? 😞

Hopefully somebody out there can provide me with some help 🙂

Best wishes and thx,
Gøran

[Mike_Marino]

Can you try adding:

/Action=install

According to http://msdn.microsoft.com/en-us/library/ms144259.aspx

That is required when using /qs

[SaberRider]

thx for the fast answer...

but... if I'd use all required commands, the call should lool like this...

/qs /ACTION=install /FEATURES=SQLEngine, FullText /INSTANCENAME=HUHU /AGTSVCACCOUNT=XXXXXXX /AGTSVCPASSWORD=XXXXXXXXX /ASSVCACCOUNT=YYYYYYYYY /ASSVCPASSWORD=YYYYYYYYYY /SAPWD=test123 /SQLSVCACCOUNT=ZZZZZZ /SQLSVCPASSWORD=YYYYYY
/SQLSVCSTARTUPTYPE=automatic /SQLSYSADMINACCOUNTS=WWWWWWWWWWWWWWW /ISSVCACCOUNT=VVVVVVVV /ISSVCACCOUNT=VVVVVVVVVVVVV /RSSVCACCOUNT=UUUUUUUUUUU /RSSVCPASSWORD=UUUUUUUUUUUU

But I don't need ReportingServices, etc. I just need a simple databaseinstance.

P.s.:Adding /ACTION=install to my commandline call doesn't solve my problem.

Best wishes from germany,
Gøran

[Mike_Marino]

Have you looked at the log file to see if it reveals any reasons for the failure (see http://msdn.microsoft.com/en-us/library/ms144287.aspx)

[SaberRider]

Hi again...

using this

/qs /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLEXPRESS /SECURITYMODE="SQL" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SAPWD="test" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM"

the SQL Server 2008 is installed without error ( looks like ) but the SQL Server Browser Service is disabled and can't be startet.

In addition to this fact I found some Errorentries in the ErrorLog

=====================================
.
.
.
2009-07-07 17:21:59.29 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.29 spid7s Cannot find the object 'system_parameters', because it does not exist or you do not have permission.
2009-07-07 17:21:59.29 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.29 spid7s Cannot find the object 'parameters', because it does not exist or you do not have permission.
2009-07-07 17:21:59.30 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.30 spid7s Cannot find the object 'system_columns', because it does not exist or you do not have permission.
2009-07-07 17:21:59.30 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.30 spid7s Cannot find the object 'columns', because it does not exist or you do not have permission.
2009-07-07 17:21:59.30 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.30 spid7s Cannot find the object 'system_views', because it does not exist or you do not have permission.
2009-07-07 17:21:59.31 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.31 spid7s Cannot find the object 'system_objects', because it does not exist or you do not have permission.
2009-07-07 17:21:59.31 spid7s Error: 15151, Severity: 16, State: 1.
2009-07-07 17:21:59.31 spid7s Cannot find the object 'extended_procedures', because it does not exist or you do not have permission.
2009-07-07 17:21:59.31 spid7s Error: 15151, Severity: 16, State: 1.
.
.
.
=======================================================

Any Ideas? The SQL Server's killing my nervs -.-

[SaberRider]

ok

this is working -->

/qs /ACTION=Install /BROWSERSVCSTARTUPTYPE=Automatic /SQLSVCSTARTUPTYPE=Automatic /FEATURES=SQL /INSTANCENAME=SQLEXPRESS /SECURITYMODE="SQL" /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SAPWD="insert" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\Network"


just the Firewall is between a working connection and you.

greetings,
Gøran

[sunil_ror]

I am using the below command line and able to install successfully
//Instance name
szInstanceName = "SQLExpress" ;

RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE);
szWinLogInKey="SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Winlogon";
//Domain name
RegDBGetKeyValueEx(szWinLogInKey,"DefaultDomainName",nvType,svDomain,nvSize);
//User name
RegDBGetKeyValueEx(szWinLogInKey,"DefaultUserName",nvType,svUser,nvSize);
szPWServiceUser=svDomain^svUser;
//By using the below command I am successfully able to install SQL Server 2008 Express. To install full change the name of instance to SQLSERVER szSQLCommand="/QS /ACTION=Install /FEATURES=SQL,SSMS /INSTANCENAME="+szInstanceName+" /SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /SQLSYSADMINACCOUNTS=\""+szPWServiceUser+"\" ";

[mike1983]

sunil.ror wrote:
I am using the below command line and able to install successfully
//Instance name
szInstanceName = "SQLExpress" ;

RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE);
szWinLogInKey="SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Winlogon";
//Domain name
RegDBGetKeyValueEx(szWinLogInKey,"DefaultDomainName",nvType,svDomain,nvSize);
//User name
RegDBGetKeyValueEx(szWinLogInKey,"DefaultUserName",nvType,svUser,nvSize);
szPWServiceUser=svDomain^svUser;
//By using the below command I am successfully able to install SQL Server 2008 Express. To install full change the name of instance to SQLSERVER szSQLCommand="/QS /ACTION=Install /FEATURES=SQL,SSMS /INSTANCENAME="+szInstanceName+" /SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /SQLSYSADMINACCOUNTS=\""+szPWServiceUser+"\" ";

entered in Prerequisite Editor?