How-to create an unattended SQL Install mode.

1-Create cmd file  with below Code text and save it as

<CD Drive letter>:\setup.exe /Configurationfile=”ConfigurationFile.ini” /IAcceptSQLServerLicenseTerms

2-Create ConfigurationFile.ini file below with the Code text below, and saved it in  c:\SQLSilentInstall\

Configure the parameters highlighted in red.


;SQL SERVER 2012 Configuration File

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.

; Detailed help for command line argument ROLE has not been defined yet.

; Detailed help for command line argument ENU has not been defined yet.

; Setup will not display any user interface.

; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.

; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality 
Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server 
Data Tools, and other shared components.

Specifies the list of administrator accounts that need to be provisioned.

; Windows account(s) to provision as SQL Server system administrators.

; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to 
enable and 0 or False to disable this feature.

; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to 
enable and 0 or False to disable this feature.

; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and 
SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine 
(SQL), Analysis Services (AS), or Reporting Services (RS).

; RSInputSettings_RSInstallMode_Description

; Don't provision current user as a Database Engine system administrator.

3-Run cmd prompt as Administrator, cd to  c:\SQLSilentInstall\

4-Run  InstallSQL.cmd

Articolo precedenteHow-to – Install NagiosQL
Prossimo articoloLVM – Recovering
Founder of Sys Admin and IT Manager