Command for silent installation of a SQL Server 2008 R2 enterprise edition and enable SQL authentication
The silent installation of the sql server is done through command prompt. The command to do that is as follows:-
SQLSetup.exe /Q /ConfigurationFile="C:\SQLServer2008\MyConfigFile.ini"
Where the SQLSetup.exe is the setup file
/Q :- Specifies the quiet mode where the setup will run without displaying a GUI or messages and doesn’t accept any user input. Let’s say it happens in the background.
If we want to know the progress of the installation then we need to use the /QS option.
Note:- UIMode=”AutoAdvanced” cannot be used with QUIET="True|False" and QUIETSIMPLE="True|False" options.
The contents of the MyConfigFile.ini is little tricky because all the parameters doesn’t match in the installation for e.g. the ADDCURRENTUSERASSQLADMIN=” True|False”,ENABLERANU=” True|False” doesn’t work for Sql Server 2008 R2 enterprise edition. They are only required for SQL Server 2008 R2 Express edition. The parameter IACCEPTSQLSERVERLICENSETERMS=”True|False”is used only in SQL Server 2008 R2 enterprise edition.
The parameters for SQL Server 2008 R2 enterprise edition config.ini are as follows
[SQLServer2008]
INSTANCEID="MYNEWSQLEXPRESS"
ACTION="Install"
FEATURES=SQLENGINE
HELP="False"
INDICATEPROGRESS="False"
X86="False"
ERRORREPORTING="False"
SQMREPORTING="False"
INSTANCENAME="MySQLEXPRESS"
SQLSVCSTARTUPTYPE="Automatic"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SQLSYSADMINACCOUNTS="domain\UserID"
SQLSVCSTARTUPTYPE="Automatic"
SECURITYMODE="SQL"
SAPWD="myPassword123456$$"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE="Disabled"
ISSVCACCOUNT="NT AUTHORITY\NetworkService"
ISSVCSTARTUPTYPE="Automatic"
QUIET="True"
QUIETSIMPLE="False"
ROLE="AllFeatures_WithDefaults"
RSINSTALLMODE="FilesOnlyMode"
RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
RSSVCSTARTUPTYPE="Automatic"
ASBACKUPDIR="Backup"
ASCOLLATION="Latin1_General_CI_AS"
ASCONFIGDIR="Config"
ASDATADIR="Data"
ASLOGDIR="Log"
ASPROVIDERMSOLAP="1"
ASSVCSTARTUPTYPE="Automatic"
ASTEMPDIR="Temp"
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
|
After the installation is done we can check the Summary.txt for the installation success or failures. It can be found in the path C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\
No comments:
Post a Comment