Command to do a silent installation in Sql Server 2008 R2 Express Edition and enable SQL Server authentication mode with TCP Port Enablement
SQLEXPRSetup.exe /QS /ConfigurationFile="C:\SilentDemoSQLServer2008R2Setup\MyConfigurationFile.ini"
Where SQLEXPRSetup.exe is the setup file which is in the folder C:\SilentDemoSQLServer2008R2Setup
/QS for quiet and simple where you can see the messages else we can use /q option for silent installation
Express Edition config file
[SQLServer2008]
INSTANCEID="MYNEWSQLEXP"
ACTION="Install"
FEATURES=SQLENGINE,ADV_SSMS
HELP="False"
INDICATEPROGRESS="False"
QUIET="False"
QUIETSIMPLE="True"
X86="False"
ROLE="AllFeatures_WithDefaults"
ENU="True"
ERRORREPORTING="False"
SQMREPORTING="False"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE="Automatic"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
ASSVCSTARTUPTYPE="Automatic"
ASCOLLATION="Latin1_General_CI_AS"
ASDATADIR="Data"
ASLOGDIR="Log"
ASBACKUPDIR="Backup"
ASTEMPDIR="Temp"
ASCONFIGDIR="Config"
ASPROVIDERMSOLAP="1"
FARMADMINPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="True"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
SECURITYMODE="SQL"
ADDCURRENTUSERASSQLADMIN="True"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"
RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
RSSVCSTARTUPTYPE="Automatic"
INSTANCENAME="SUBBUSQLEXP"
SAPWD="Subbu123456$$"
IACCEPTSQLSERVERLICENSETERMS="True"
Other Feature Parameter
SQLENGINE
|
For SQL Engine
|
SSMS
|
Sql Server Management Studio
|
AS
|
Analysis Services
|
RS
|
Reporting Services
|
IS
|
Integration Services
|
Tools
|
SQL Tools
|
BIDS
|
Business Intelligence Development Studio
|
ADV_SSMS
|
Installs all the SQL Server management tools
|
REPLICATION
|
SQL replication
|
No comments:
Post a Comment