Waclaw Chrabaszcz
... there is no spoon ...

SQL 2008 Express silent installation

Wednesday, December 12, 2012 4:33 PM

Wow! Today we have 12.12.12.

How many times you needed "quick SQL" for your tests … Let's make it quick.

Command line:

Setup.exe /ConfigurationFile=SQLExpress.ini /Q

However we need an answer file. One for SQL Express, another for SQL Enterprise. You can easy prepare the answer file using manual installation. Within last step of the installer GUI you will see:

Time for SQLExpress.ini – don't forget to review all settings and replace PCUSOURCE & SQLSYSADMINACCOUNTS settings:

   

[SQLSERVER2008]
INSTANCEID="SQLExpress"
ACTION="Install"
FEATURES=SQLENGINE
HELP="False"
INDICATEPROGRESS="False"
QUIET="False"
QUIETSIMPLE="False"
X86="True"
PCUSOURCE="C:\install\SqlExpress_2008\PCUSOURCE"
ERRORREPORTING="False"
INSTALLSHAREDDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCEDIR="C:\Program Files (x86)\Microsoft SQL Server"
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"
SQLSYSADMINACCOUNTS="DOMAIN\Administrator"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="0"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"

   

  




Feedback

# re: SQL 2008 Express silent installation

Downloading the Snapchat for ios Follow these steps to install the Snapchat android app on your Samsung Galaxy device. 1/5/2016 5:26 AM | Heath

# re: SQL 2008 Express silent installation

To me It seems a great idea! sure i will try this on my websitecheckcrditcardstatus 3/14/2016 7:58 PM | Melvinrajiv

# re: SQL 2008 Express silent installation

visit this site for wonder ful applications and games to download ree <a href="http://http://www.androidlake.com/"<android lake 4/14/2016 11:53 PM | kevin

# re: SQL 2008 Express silent installation

visit this wonder ful site for tons of free stuffandroid lake 4/14/2016 11:55 PM | kevin

# re: SQL 2008 Express silent installation

visit this site for top mothers day pics and gifs
happy mothers day greetings 4/14/2016 11:57 PM | dave

# re: SQL 2008 Express silent installation

you can find the best Top 3 internet browsers 4/15/2016 12:00 AM | paul

# re: SQL 2008 Express silent installation

Thanks for sharing the great article.

HDFC Credit card status online

https://getcardstatus.in/ 7/19/2016 8:06 PM | nikki

Post a comment