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

Post a comment