SQL 2008 Express silent installation

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"

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/dPq