This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: SQL 2008 Express install via command line
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2009
04:16 AM
SQL 2008 Express install via command line
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
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
(7) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2009
06:57 AM
Can you try adding:
/Action=install
According to http://msdn.microsoft.com/en-us/library/ms144259.aspx
That is required when using /qs
/Action=install
According to http://msdn.microsoft.com/en-us/library/ms144259.aspx
That is required when using /qs
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2009
08:07 AM
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
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
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2009
10:18 AM
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)
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2009
10:52 AM
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 -.-
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 -.-
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 08, 2009
06:16 AM
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
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
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 23, 2009
06:56 AM
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+"\" ";
//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+"\" ";
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 13, 2010
02:03 PM
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?