Install SQL server using the command line

Note: To perform Silent Installation,

You need to change the quiet parameter to true,

Delete or comment out the uimode parameter,

Then run the setup program in the command line window:

Setup.exe/Q/examples = "mssqld"/sqlsvcpassword = "mssqld"/assvcpassword = "mssqld"/Signature = "mssqld"/issvcpassword = "mssqld "/sapwd =" mssqld "/configurationfile =" D: \ configurationfile. ini"

/PID = "K8TCY-WY3TW-H2BCG-WTYV2-C96HM" otherwise installed is the evaluation version, 180 days

To append an instance, follow these steps;

Replace Instance name (Case Insensitive)

Features = sqlengine, replication, Fulltext, As, RS

========================================================== ========================================================== ==========

; Sqlserver2008 configuration file

[Sqlserver2008]

; Specifies the instance ID for the SQL server function you have specified. The SQL Server Directory structure, registry structure, and service name reflect the instance id of the SQL server instance.

Instanceid = "msins2"

; Specifies the workflow of the installer, such as install, uninstall, or upgrade. This is a required parameter.

Action = "Install"

; Specifies the features to install, uninstall, or upgrade. The list of top-level functions includes SQL, As, RS, is, and tools. The SQL function will install the database engine, copy, and full text. Management tools, books online, business intelligence development studio, and other shared components will be installed.

Features = sqlengine, replication, Fulltext, As, RS, bids, Conn, is, BC, SDK, bol, SSMs, adv_ssms, snac_sdk, OCS

To append an instance, follow these steps:

; Features = sqlengine, replication, Fulltext, As, RS

; Display command line parameter usage

Help = "false"

; Specify that detailed installation program logs should be sent to the console.

Indicateprogress = "false"

The installer will not display any user interface.

Quiet = "true"

The installer only displays the progress without any user interaction.

Quietsimple = "false"

; Specifies that the installer should be installed in wow64. The IA64 or 32-bit system does not support this command line parameter.

X86 = "false"

; Detailed Help for the command line parameter enu has not been defined.

Enu = "false"

Parameters used to control user interface behavior. Valid values are normal for the complete UI and autoadvance for the simplified UI.

; Uimode = "normal"

; Specifies whether to report errors to Microsoft to improve the SQL Server version later. If you specify 1 or true, this function is enabled. If you specify 0 or false, this function is disabled.

Errorreporting = "false"

; Specifies the installation root directory of the Local Shared components.

Installshareddir = "C: \ Program Files \ Microsoft SQL Server"

; Specifies the installation root directory of the wow64 shared component.

Installsharedwowdir = "C: \ Program Files (x86) \ Microsoft SQL Server"

; Specifies the installation directory.

Instancedir = "C: \ Program Files \ Microsoft SQL Server"

To collect SQL Server Function usage data and send the data to Microsoft. If you specify 1 or true, this function is enabled. If you specify 0 or false, this function is disabled.

Sqmreporting = "false"

; Specifies the default instance or named instance. MSSQLServer is a non-Express default instance, while sqlexpress is the default instance of Express. This parameter is required when you install the SQL Server database engine (SQL), analysis services (AS), or reporting services (RS.

InstanceName = "msins2"

; Proxy account name

Agtsvcaccount = "mssqld"

The service is automatically started after installation.

Agtsvcstartuptype = "disabled"

; The Startup type of integration services.

Issvcstartuptype = "disabled"

; Integration services account: domain \ User or system account.

Issvcaccount = "mssqld"

The name of the account used to run the analysis services service.

Assvcaccount = "mssqld"

; After creating a service, control the Service Startup type settings.

Assvcstartuptype = "disabled"

; The sorting rules to be used by analysis services.

Ascollation = "chinese_prc_ci_as"

The location of the analysis services data file.

Asdatadir = "C: \ Program Files \ Microsoft SQL Server \ msas10_50.msins2 \ OLAP \ data"

The location of the Analysis Services log file.

Aslogdir = "C: \ Program Files \ Microsoft SQL Server \ msas10_50.msins2 \ OLAP \ log"

The location of the Analysis Services backup file.

Asbackupdir = "C: \ Program Files \ Microsoft SQL Server \ msas10_50.msins2 \ OLAP \ backup"

; The location of the Temporary Analysis Services file.

Astempdir = "C: \ Program Files \ Microsoft SQL Server \ msas10_50.msins2 \ OLAP \ Temp"

The location of the analysis services configuration file.

Asconfigdir = "C: \ Program Files \ Microsoft SQL Server \ msas10_50.msins2 \ OLAP \ config"

; Specifies whether msolap access interfaces are allowed to run in the process.

Asprovidermsolap = "1"

; Specifies the list of administrator accounts to be set.

Assysadminaccounts = "mssqld"

The port number used to connect to the Web application of the SharePoint management center.

Farmadminport = "0"

The START type of the SQL Server service.

Sqlsvcstartuptype = "automatic"

; Enable the filestream function level (0, 1, 2, or 3 ).

Filestreamlevel = "0"

; Set to "1" to enable ranu for SQL Server Express.

Enableranu = "false"

; Specifies the windows or SQL sorting rules to be used for the database engine.

Sqlcollation = "chinese_prc_ci_as"

; SQL Server service account: domain \ User or system account.

Sqlsvcaccount = "mssqld"

To be set as the Windows Account of the SQL Server System Administrator.

Sqlsysadminaccounts = "mssqld"

The default value is Windows authentication. "SQL" indicates mixed authentication.

Securitymode = "SQL"

Database Engine root data directory.

Installsqldatadir = "D: \ msins2"

The default directory of the Database Engine backup file.

Sqlbackupdir = "D: \ msins2 \ backup"

The default directory of the Database Engine user database.

Sqluserdbdir = "D: \ msins2 \ data"

The default directory of database logs of database engines.

Sqluserdblogdir = "D: \ msins2 \ log"

; Database Engine tempdb file directory.

Sqltempdbdir = "D: \ msins2 \ tmp"

; The directory of the Database Engine tempdb log file.

Sqltempdblogdir = "D: \ msins2 \ tmplog"

Set the current user as the database engine system administrator of SQL Server 2008 R2 Express.

Addcurrentuserassqladmin = "false"

Specify 0 to disable the TCP/IP protocol, and 1 to enable the Protocol.

Tcpenabled = "1"

Specify 0 to disable the Named Pipes protocol, and 1 to enable the Protocol.

Npenabled = "0"

Browser Service Startup type.

Browsersvcstartuptype = "disabled"

; Specifies the account that the Report Server NT Service should use during execution. If this value is omitted or the value is a null string, the default built-in account of the current operating system is used.

; The maximum length of the rssvcaccount user name is 20 characters,

The maximum length of the rssvcaccount domain is 254 characters.

Rssvcaccount = ". \ mssqld"

; Specifies the start mode of the Report Server NT Service.

; Manual-start the service in manual mode (default.

; Automatic-start the service in automatic mode.

; Disabled-the Service is Disabled

Rssvcstartuptype = "disabled"

; Specifies the installation mode of the Report Server.

; Default value: "filesonly"

Rsinstallmode = "defaultnativemode"

; Add the description of the input parameter ftsvcaccount

Ftsvcaccount = "mssqld"

Ftsvcstartuptype = "disabled"