Install SQL Server 2014 Express via command line

Question

How can I install SQL Server 2014 Express via command line on a new Windows 7 machine?

I tried the following command line; I didn't see any SQL service running or installed although no errors were shown. So what's the wrong with it? Any idea?

SQLEXPRESS.EXE /qs /ACTION=Install /FEATURES=SQLEngine 
               /INSTANCENAME=SQLEXPRESS 
               /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" 
               /SQLSVCPASSWORD="STR0NGP@$$" 
               /SQLSYSADMINACCOUNTS="NT AUTHORITY\NETWORK SERVICE" 
               /AGTSVCACCOUNT="NT AUTHORITY\Network Service" 
               /TCPENABLED=0 /X86="True" /SQMREPORTING="False" 
               /ISSVCSTARTUPTYPE="Automatic"  
               /ASCOLLATION="Latin1_General_CI_AS" 
               /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"  
               /RSINSTALLMODE="FilesOnlyMode"
               /IACCEPTSQLSERVERLICENSETERMS

why the down vote!? if you don't know the solution simply leave the post. — MarwaAhmad
– MarwaAhmad, Commented Mar 7, 2016 at 10:51
I didn't see a downvote, but I did vote to close in order to move it to another site, where you'd probably get more help ;) — Stuart Ainsworth
– Stuart Ainsworth, Commented Mar 7, 2016 at 12:17

MarwaAhmad · Accepted Answer · 2016-03-10 09:39:45Z

3

Solved it: 
this will enable Mixed Authentication; SQL & windows. 
Also login using sa directly after installing the SQL server express.

SQLEXPRESS.EXE 
/IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE  
/Role="AllFeatures_WithDefaults" /INSTANCEID="SQLEXPRESS" 
/ACTION="Install" /HELP="False" /INDICATEPROGRESS="True" 
/QUIETSIMPLE="True" /X86="True" /ERRORREPORTING="False" 
/SQMREPORTING="False" /INSTANCENAME="SQLEXPRESS" 
/AGTSVCSTARTUPTYPE="Manual" /ISSVCSTARTUPTYPE="Automatic"    
/ISSVCACCOUNT="NT AUTHORITY\NetworkService"
/ASSVCSTARTUPTYPE="Automatic" /ASCOLLATION="Latin1_General_CI_AS" 
/ASDATADIR="Data" /ASLOGDIR="Log" /ASBACKUPDIR="Backup" /ASTEMPDIR="Temp" 
/ASCONFIGDIR="Config" /ASPROVIDERMSOLAP="1" 
/SQLSVCSTARTUPTYPE="Automatic"
/FILESTREAMLEVEL="0" /ENABLERANU="True"     
/SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" 
/SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" 
/ADDCURRENTUSERASSQLADMIN="True" 
/TCPENABLED="0" /NPENABLED="0" 
/BROWSERSVCSTARTUPTYPE="Disabled" /RSSVCSTARTUPTYPE="Automatic" /SECURITYMODE=SQL 
/SAPWD="Strong1Pa$$word"

edited Mar 10, 2016 at 9:39

answered Mar 7, 2016 at 10:52

MarwaAhmad

89410 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nick.Mc Over a year ago

This would not explain "I didn't see any SQL service running or installed" but I'm glad you solved it

MarwaAhmad Over a year ago

That was because the SQLServerExpress installer got extracted only but not installed.

Collectives™ on Stack Overflow

Install SQL Server 2014 Express via command line

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related