How to: Install SQL Server 2008 from the Command Prompt

How to: Install SQL Server 2008 from the Comman...

SQL Server 2008 Books Online (October 2009)

New: 31 October 2008

Before you run SQL Server Setup, review Planning a SQL Server Installation.

Installing a new instance of SQL Server at the command prompt enables you to specify the features to install and how they should be configured. You can also specify silent, basic, or full interaction with the Setup user interface.

Note:
When installing through the command prompt, SQL Server supports full quiet mode by using the /Q parameter or Quiet Simple mode by using the /QS parameter. The /QS switch only shows progress, does not accept any input, and displays no error messages if encountered. The /QS parameter is only supported when /Action=install is specified.

Command prompt installation is supported in the following scenarios:

Installing, upgrading, or removing an instance and shared components of SQL Server 2008 on a local computer by using syntax and parameters specified at the command prompt.
Installing, upgrading, or removing a failover cluster instance.
Upgrading from one SQL Server 2008 edition to another edition of SQL Server 2008.
Installing an instance of SQL Server 2008 on a local computer by using syntax and parameters specified in a configuration file. You can use this method to copy an installation configuration to multiple computers, or to install multiple nodes of a failover cluster installation.

When you install SQL Server at the command prompt, specify Setup parameters for your installation at the command prompt as part of your installation syntax.

Note:
For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share. For failover cluster installations, you must be a local administrator with permissions to login as a service, and to act as part of the operating system on all failover cluster nodes.

Proper Use of Setup Parameters

Use the following guidelines to develop installation commands that have correct syntax:

/PARAMETER
/PARAMETER=true/false
/PARAMETER=1/0 for Boolean types
/PARAMETER="value" for all single-value parameters. Using double quotation marks is recommended, but required if the value contains a space

Note:
/PID, the value for this parameter should be enclosed in double quotation marks
/PARAMETER="value1" "value2" "value3" for all multiple-value parameters. Using double quotation marks is recommended, but required if the value contains a space

Note:
/PID, the value for this parameter should be enclosed in double quotation marks

Exceptions:

/FEATURES, which is a multivalued parameter, but its format is /FEATURES=AS,RS,IS without a space, comma-delimited

Note the use of escaping characters:

/INSTANCEDIR=c:\PathName is supported.
/INSTANCEDIR=c:\PathName\ is supported
/INSTANCEDIR="c:\PathName\\" is supported.
/INSTANCEDIR="c:\PathName\" is not supported.

SQL Server 2008 Parameters

The following sections provide parameters to develop command line installation scripts for install, update, and repair scenarios.

Parameters that are listed for a SQL Server component are specific to that component. SQL Server Agent and SQL Server Browser parameters are applicable when you install the SQL Server Database Engine.

Installation Parameters
Upgrade Parameters
Repair Parameters
Rebuild System Database Parameters
Uninstall Parameters
Failover Cluster Parameters
Parameters from Previous SQL Server Versions
Service Accounts Parameters
Feature Parameters

Installation Parameters

Use the parameters in the following table to develop command line scripts for installation.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: Install
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/ERRORREPORTING Optional	Specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/FEATURES Required	Specifies components to install.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for installation parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
SQL Server Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components.
SQL Server Setup Control	/INSTALLSHAREDWOWDIR Optional	Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system.
SQL Server Setup Control	/INSTANCEDIR Optional	Specifies a nondefault installation directory for instance-specific components.
SQL Server Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/QS Optional	Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server Setup Control	/SQMREPORTING Optional	Specifies feature usage reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
SQL Server Agent	/AGTSVCACCOUNT Required	Specifies the account for the SQL Server Agent service.
SQL Server Agent	/AGTSVCPASSWORD Required	Specifies the password for SQL Server Agent service account.
SQL Server Agent	/AGTSVCSTARTUPTYPE Optional	Specifies the startup mode for the SQL Server Agent service. Supported values: Automatic Disabled Manual
Analysis Services	/ASBACKUPDIR Optional	Specifies the directory for Analysis Services backup files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Backup. For all other installations: %Program Files%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
Analysis Services	/ASCOLLATION Optional	Specifies the collation setting for Analysis Services. Default value: Latin1_General_CI_AS
Analysis Services	/ASCONFIGDIR Optional	Specifies the directory for Analysis Services configuration files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Config. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.
Analysis Services	/ASDATADIR Optional	Specifies the directory for Analysis Services data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.
Analysis Services	/ASLOGDIR Optional	Specifies the directory for Analysis Services log files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log.
Analysis Services	/ASSVCACCOUNT Required	Specifies the account for the Analysis Services service.
Analysis Services	/ASSVCPASSWORD Required	Specifies the password for the Analysis Services service.
Analysis Services	/ASSVCSTARTUPTYPE Optional	Specifies the startup mode for the Analysis Services service. Supported values: Automatic Disabled Manual
Analysis Services	/ASSYSADMINACCOUNTS Required	Specifies the administrator credentials for Analysis Services.
Analysis Services	/ASTEMPDIR Optional	Specifies the directory for Analysis Services temporary files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
Analysis Services	/ASPROVIDERMSOLAP Optional	Specifies whether the MSOLAP provider can run in-process. Default value: 1=enabled
SQL Server Browser	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for SQL Server Browser service. Supported values: Automatic Disabled Manual
SQL Server Database Engine	/ENABLERANU Optional	Enables run-as credentials for SQL Server Express installations.
SQL Server Database Engine	/INSTALLSQLDATADIR Optional	Specifies the data directory for SQL Server data files. Default values: For WOW mode on 64-bit:%Program Files(x86)%\Microsoft SQL Server\ For all other installations:%Program Files%\Microsoft SQL Server\
SQL Server Database Engine	/SAPWD Required when /SECURITYMODE=SQL	Specifies the password for the SQL Server sa account.
SQL Server Database Engine	/SECURITYMODE Optional	Specifies the security mode for SQL Server. If this parameter is not supplied, then Windows-only authentication mode is supported. Supported value: SQL
SQL Server Database Engine	/SQLBACKUPDIR Optional	Specifies the directory for backup files. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup
SQL Server Database Engine	/SQLCOLLATION Optional	Specifies the collation settings for SQL Server. Default value: SQL_Latin1_General_CP1_CS_AS
SQL Server Database Engine	/SQLSVCACCOUNT Required	Specifies the startup account for the SQL Server service.
SQL Server Database Engine	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT.
SQL Server Database Engine	/SQLSVCSTARTUPTYPE Optional	Specifies the startup mode for the SQL Server service. Supported values: Automatic Disabled Manual
SQL Server Database Engine	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role.
SQL Server Database Engine	/SQLTEMPDBDIR Optional	Specifies the directory for the data files for tempdb. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLTEMPDBLOGDIR Optional	Specifies the directory for the log files for tempdb. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLUSERDBDIR Optional	Specifies the directory for the data files for user databases. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLUSERDBLOGDIR Optional	Specifies the directory for the log files for user databases. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/USESYSDB Optional	Specifies the location of the SQL Server system databases to use for this installation. The path that is specified must not include the "\Data" suffix.
FILESTREAM	/FILESTREAMLEVEL Optional	Specifies the access level for the FILESTREAM feature. Supported values: 0 =Disable FILESTREAM support for this instance. (Default value) 1=Enable FILESTREAM for Transact-SQL access. 2=Enable FILESTREAM for Transact-SQL and file I/O streaming access. (Not valid for cluster scenarios) 3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAM	/FILESTREAMSHARENAME Optional Required when FILESTREAMLEVEL is greater than 1.	Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems. ServiceSID is used to help secure the communication between SQL Server and Full-text Filter Daemon. If the values are not provided, the Full-text Filter Launcher Service is disabled. You have to use SQL Server Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
SQL Server Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems.
Integration Services	/ISSVCACCOUNT Required	Specifies the account for Integration Services. Default value: NT AUTHORITY\NETWORK SERVICE
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Integration Services	/ISSVCStartupType Optional	Specifies the startup mode for the Integration Services service.
SQL Server Network Configuration	/NPENABLED Optional	Specifies the state of the Named Pipes protocol for the SQL Server service. Supported values: 0=disable the Named Pipes protocol 1=enable the Named Pipes protocol
SQL Server Network Configuration	/TCPENABLED Optional	Specifies the state of the TCP protocol for the SQL Server service. Supported values: 0=disable the TCP protocol 1=enable the TCP protocol
Reporting Services	/RSINSTALLMODE Optional	Specifies the Install mode for Reporting Services.
Reporting Services	/RSSVCACCOUNT Required	Specifies the startup account for Reporting Services.
Reporting Services	/RSSVCPASSWORD Required	Specifies the password for the startup account for the Reporting Services service.
Reporting Services	/RSSVCStartupType Optional	Specifies the startup mode for Reporting Services.

Sample Syntax:

To install a new, stand-alone instance with the SQL Server Database Engine, Replication, and Full-Text Search components.

Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service"

Upgrade Parameters

Use the parameters in the following table to develop command-line scripts for upgrade.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: Upgrade
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/ERRORREPORTING Optional	Specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/ INSTANCEDIR Optional	Specifies a nondefault installation directory for shared components.
SQL Server Setup Control	/INSTANCEID Required when you upgrade from SQL Server 2008 Optional when you upgrade from SQL Server 2000 and SQL Server 2005	Specifies a nondefault value for an InstanceID.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/SQMREPORTING Optional	Specifies feature usage reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies the console window would be hidden or closed.
SQL Server Browser Service	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for SQL Server Browser service Supported values: Automatic Disabled Manual
SQL Server Full-Text	/FTUPGRADEOPTION Optional	Specifies the Full-Text catalog upgrade option. Supported values: REBUILD RESET IMPORT
Integration Services	/ISSVCACCOUNT Required	Specifies the account for Integration Services. Default value: NT AUTHORITY\NETWORK SERVICE
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Integration Services	/ISSVCStartupType Optional	Specifies the startup mode for the Integration Services service.
Reporting Services	/RSUPGRADEDATABASEACCOUNT Optional
Reporting Services	/RSUPGRADEPASSWORD Optional

Sample Syntax:

To upgrade an existing instance or failover cluster node from SQL Server 2000 or SQL Server 2005.

Setup.exe /q /ACTION=upgrade /INSTANCENAME=MSSQLSERVER /RSUPGRADEDATABASEACCOUNT="<Provide a SQL Server logon account that can connect to the report server during upgrade>" /RSUPGRADEPASSWORD="<Provide a password for the report server upgrade account>" /ISSVCAccount="NT Authority\Network Service"

To upgrade an existing instance of SQL Server 2008 to a different edition of SQL Server 2008.

Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=MSSQLSERVER /PID=<PID key for new edition>"

Repair Parameters

Use the parameters in the following table to develop command-line scripts for repair.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the repair workflow. Supported values: Repair
SQL Server Setup Control	/FEATURES Required	Specifies components to repair.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.

Sample Syntax:

Repair an instance and shared components.

Setup.exe /q /ACTION=Repair /INSTANCENAME=<instancename>

Rebuild System Database Parameters

Use the parameters in the following table to develop command-line scripts to rebuild the master, model, msdb, and tempdb system databases. For more information, see Rebuilding System Databases.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the rebuild database workflow. Supported values: Rebuilddatabase
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Database Engine	/SQLCOLLATION Optional	Specifies a new server-level collation. Default value: SQL_Latin1_General_CP1_CS_AS
SQL Server Database Engine	/SAPWD Required when /SECURITYMODE=SQL was specified during Installation of the Instance.	Specifies the password for SQL SA account.
SQL Server Database Engine	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role.

Uninstall Parameters

Use the parameters in the following table to develop command-line scripts for uninstallation.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the uninstall work flow. Supported values: Uninstall
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/FEATURES Required	Specifies components to uninstall.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.

Sample Syntax:

To uninstall an existing instance of SQL Server.

Setup.exe /Action=Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME=MSSQLSERVER

Note To remove a named instance, specify the name of the instance instead of "MSSQLSERVER" in the example that was mentioned earlier in this topic.

Failover Cluster Parameters

Before you install a SQL Server failover cluster instance, review the following topics:

Hardware and Software Requirements for Installing SQL Server 2008
Security Considerations for a SQL Server Installation
Before Installing Failover Clustering

Getting Started with SQL Server 2008 Failover Clustering

Important:
All failover cluster installation commands require an underlying Windows cluster. All the nodes that will be part of a SQL Server failover cluster must be part of the same Windows cluster.

Test and modify the following failover cluster installation scripts to meet the needs of your organization.

Integrated Install Failover Cluster Parameters

Use the parameters in the following table to develop command-line scripts for failover cluster installation.

For more information about Integrated Installation, see Getting Started with SQL Server 2008 Failover Clustering.

Note:
To add more nodes after the installation, use Add Node action.

SQL Server component	Parameter	Details
SQL Server Setup Control	/ACTION Required	Required to indicate the failover cluster installation work flow. Supported values: InstallFailoverCluster
SQL Server Setup Control	/FAILOVERCLUSTERGROUP Optional	Specifies the name of the resource group to be used for the SQL Server failover cluster. It can be the name of an existing cluster group or the name of a new resource group. Default value: SQLServer(<InstanceName>)
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/ERRORREPORTING Optional	Specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/FEATURES Required	Specifies components to install.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components.
SQL Server Setup Control	/INSTALLSHAREDWOWDIR Optional	Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system.
SQL Server Setup Control	/INSTANCEDIR Optional	Specifies nondefault installation directory for instance-specific components.
SQL Server Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/QS Optional	Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server Setup Control	/SQMREPORTING Optional	Specifies feature usage reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies the console window would be hidden or closed.
SQL Server Setup Control	/FAILOVERCLUSTERDISKS Required	Specifies the list of shared disks to be included in the SQL Server failover cluster resource group. Default value: The first drive is used as the default drive for all databases.
SQL Server Setup Control	/FAILOVERCLUSTERIPADDRESSES Required	Specifies the list of IP addresses for the SQL Server failover cluster.
SQL Server Setup Control	/FAILOVERCLUSTERNETWORKNAME Required	Specifies the network name for the new SQL Server failover cluster. This name is used to identify the new SQL Server failover cluster instance on the network.
SQL Server Agent	/AGTSVCACCOUNT Required	Specifies the account for the SQL Server Agent service.
SQL Server Agent	/AGTSVCPASSWORD Required	Specifies the password for SQL Server Agent service account.
SQL Server Agent	/AGTDOMAINGROUP Required 1	Specifies global or local security domain group for the SQL Server Agent service. All resource permissions are controlled by domain-level security group that includes the service account as a member.
Analysis Services	/ASBACKUPDIR Optional	Specifies the directory for Analysis Services backup files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup. For all other installations:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
Analysis Services	/ASCOLLATION Optional	Specifies the collation setting for Analysis Services. Default value: Latin1_General_CI_AS
Analysis Services	/ASCONFIGDIR Optional	Specifies the directory for Analysis Services configuration files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.
Analysis Services	/ASDATADIR Optional	Specifies the directory for Analysis Services data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.
Analysis Services	/ASLOGDIR Optional	Specifies the directory for Analysis Services log files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log.
Analysis Services	/ASSYSADMINACCOUNTS Required	Specifies the administrator credentials for Analysis Services.
Analysis Services	/ASTEMPDIR Optional	Specifies the directory for Analysis Services temporary files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp. For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
Analysis Services	/ASPROVIDERMSOLAP Optional	Specifies whether the MSOLAP provider can run in-process. Default value: 1=enabled
Analysis Services	/ASDOMAINGROUP Required 1	Specifies the global or local security domain group for Analysis Services service. All resource permissions are controlled by the domain-level security group that includes the service account as a member.
SQL Server Database Engine	/INSTALLSQLDATADIR Required only if no shared disk is available	Specifies the data directory for SQL Server data files. If INSTALLDATADIR is not specified and there are shared disks available, the first available shared disk is set as the data directory.
SQL Server Database Engine	/SAPWD Required when /SECURITYMODE=SQL	Specifies the password for the SQL Server sa account.
SQL Server Database Engine	/SECURITYMODE Optional	Specifies the security mode for SQL Server. If this parameter is not supplied, then Windows-only authentication mode is supported. Supported value: SQL
SQL Server Database Engine	/SQLBACKUPDIR Optional	Specifies the directory for backup files. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup.
SQL Server Database Engine	/SQLCOLLATION Optional	Specifies the collation settings for SQL Server. Default value: SQL_Latin1_General_CP1_CS_AS
SQL Server Database Engine	/SQLSVCACCOUNT Required	Specifies the startup account for the SQL Server service.
SQL Server Database Engine	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT.
SQL Server Database Engine	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role.
SQL Server Database Engine	/SQLTEMPDBDIR Optional	Specifies the directory for the data files for tempdb. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLTEMPDBLOGDIR Optional	Specifies the directory for the log files for tempdb. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLUSERDBDIR Optional	Specifies the directory for the data files for user databases. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/SQLUSERDBLOGDIR Optional	Specifies the directory for the log files for user databases. Default value: <InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database Engine	/USESYSDB Optional	Specifies the location of the SQL Server system databases to use for this installation. The path that is specified must not include the "\Data" suffix.
SQL Server Database Engine	/SQLDOMAINGROUP Required 1	Specifies global or local security domain group for the SQL Server Database Engine service. All resource permissions are controlled by domain-level security group that includes the service account as a member.
FILESTREAM	/FILESTREAMLEVEL Optional	Specifies the access level for the FILESTREAM feature. Supported values: 0 =Disable FILESTREAM support for this instance. (Default value) 1=Enable FILESTREAM for Transact-SQL access. 2=Enable FILESTREAM for Transact-SQL and file I/O streaming access. (Not valid for cluster scenarios) 3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAM	/FILESTREAMSHARENAME Optional Required when FILESTREAMLEVEL is greater than 1.	Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems. ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon. If the values are not provided the Full-text Filter Launcher Service will be disabled. You have to use SQL Server Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
SQL Server Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems.
Integration Services	/ISSVCACCOUNT Required	Specifies the account for Integration Services. Default value: NT AUTHORITY\NETWORK SERVICE
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Integration Services	/ISSVCStartupType Optional	Specifies the startup mode for the Integration Services service.
Reporting Services	/RSINSTALLMODE Optional	Specifies the Install mode for Reporting Services.
Reporting Services	/RSSVCACCOUNT Required	Specifies the startup account for Reporting Services.
Reporting Services	/RSSVCPASSWORD Required	Specifies the password for the startup account for Reporting Services service.
Reporting Services	/RSSVCStartupType Optional	Specifies the startup mode for Reporting Services.

1This parameter is required on Windows Server 2003 and in-place upgrade from SQL Server 2000 Failover Cluster to SQL Server 2008 Failover Cluster. It is optional for installations on Windows Server 2008.

Additional Notes:

Do not use domain groups on Windows Server 2008 for new installations. We recommend that you use ServiceSID on Windows Server 2008.

The Database Engine and Analysis Services are the only components that are cluster-aware. Other features are not cluster-aware and do not have high availability through failover.

Sample Syntax:

To install a single-node SQL Server failover cluster instance with the Database Engine and Analysis Services, default instance.

setup.exe /q /ACTION=InstallFailoverCluster /InstanceName=MSSQLSERVER /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\UserName>" /ASDATADIR=<Drive>:\OLAP\Data /ASLOGDIR=<Drive>:\OLAP\Log /ASBACKUPDIR=<Drive>:\OLAP\Backup /ASCONFIGDIR=<Drive>:\OLAP\Config /ASTEMPDIR=<Drive>:\OLAP\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'" /FAILOVERCLUSTERNETWORKNAME="<Insert Network Name>" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;Local Area Connection;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="MSSQLSERVER" /Features=AS,SQL /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /ASDOMAINGROUP="<DomainName\DomainGroup>" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx" /SQLDOMAINGROUP="<DomainName\DomainGroup>" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /SQLSYSADMINACCOUNTS="<DomainName\UserName>

Prepare Failover Cluster Parameters

Use the parameters in the following table to develop command-line scripts for Failover Cluster prepare. This is the first step in advanced cluster installation, where you have to prepare the failover cluster instances on all the nodes of the failover cluster. For more information, see Getting Started with SQL Server 2008 Failover Clustering.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the failover cluster prepare work flow. Supported values: PrepareFailoverCluster
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/ERRORREPORTING Optional	Specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/FEATURES Required	Specifies components to install.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components.
SQL Server Setup Control	/INSTALLSHAREDWOWDIR Optional	Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system.
SQL Server Setup Control	/INSTANCEDIR Optional	Specifies nondefault installation directory for instance specific components.
SQL Server Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/QS Optional	Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server Setup Control	/SQMREPORTING Optional	Specifies feature usage reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
SQL Server Agent	/AGTSVCACCOUNT Required	Specifies the account for the SQL Server Agent service.
SQL Server Agent	/AGTSVCPASSWORD Required	Specifies the password for SQL Server Agent service account.
SQL Server Agent	/AGTDOMAINGROUP Required 1	Specifies global or local security domain group for the SQL Server Agent service. All resource permissions are controlled by domain-level security group that includes the service account as a member.
Analysis Services	/ASSVCACCOUNT Required	Specifies the account for the Analysis Services service.
Analysis Services	/ASSVCPASSWORD Required	Specifies the password for the Analysis Services service.
Analysis Services	/ASDOMAINGROUP Required 1	Specifies the global or local security domain group for Analysis Services service. All resource permissions are controlled by the domain-level security group that includes the service account as a member.
SQL Server Database Engine	/SQLSVCACCOUNT Required	Specifies the startup account for the SQL Server service.
SQL Server Database Engine	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT.
SQL Server Database Engine	/SQLDOMAINGROUP Required 1	Specifies global or local security domain group for the SQL Server Database Engine service. All resource permissions are controlled by domain-level security group that includes the service account as a member.
FILESTREAM	/FILESTREAMLEVEL Optional	Specifies the access level for the FILESTREAM feature. Supported values: 0 =Disable FILESTREAM support for this instance. (Default value) 1=Enable FILESTREAM for Transact-SQL access. 2=Enable FILESTREAM for Transact-SQL and file I/O streaming access. (Not valid for Cluster scenarios) 3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAM	/FILESTREAMSHARENAME Optional Required when FILESTREAMLEVEL is greater than 1.	Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems. ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon. If the values are not provided the Full-text Filter Launcher Service will be disabled. You have to use SQL Server Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
SQL Server Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in Windows Server 2008 and Windows Vista operating systems.
Integration Services	/ISSVCACCOUNT Required	Specifies the account for Integration Services. Default value: NT AUTHORITY\NETWORK SERVICE
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Integration Services	/ISSVCStartupType Optional	Specifies the startup mode for the Integration Services service.
Reporting Services	/RSINSTALLMODE Available only on Files only mode.	Specifies the Install mode for Reporting Services.
Reporting Services	/RSSVCACCOUNT Required	Specifies the startup account for Reporting Services.
Reporting Services	/RSSVCPASSWORD Required	Specifies the password for the startup account for Reporting Services service.
Reporting Services	/RSSVCStartupType Optional	Specifies the startup mode for Reporting Services.

1This parameter is required on Windows Server 2003 and in-place upgrade from SQL Server 2000 or SQL Server 2005 Failover Cluster to SQL Server 2008 Failover Cluster. It is optional for installations on Windows 2008.

Sample Syntax:

To perform the "Preparation" step of a failover cluster advanced installation scenario for the Database Engine and Analysis Services.

Run the following command at the command prompt to prepare a default instance:

setup.exe /q /ACTION=PrepareFailoverCluster /InstanceName=MSSQLSERVER /Features=AS,SQL /INDICATEPROGRESS /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /ASDOMAINGROUP="<DomainName\DomainGroup>" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /SQLDOMAINGROUP="<DomainName\DomainGroup>" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx"

Run the following command at the command prompt to prepare a named instance:

setup.exe /q /ACTION=PrepareFailoverCluster /InstanceName="<Insert Instance name>" /Features=AS,SQL /INDICATEPROGRESS /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /ASDOMAINGROUP="<DomainName\DomainGroup>" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /SQLDOMAINGROUP="<DomainName\DomainGroup>" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx"

Complete Failover Cluster Parameters

Use the parameters in the following table to develop command-line scripts Failover Cluster complete. This is the second step in the advanced failover cluster install option. After you have run prepare on all the failover cluster nodes, you run this command on the node that owns the shared disk(s). For more information, see Getting Started with SQL Server 2008 Failover Clustering.

SQL Server component

Parameter

Description

SQL Server Setup Control

/ACTION

Required

Required to indicate the failover cluster complete work flow.

Supported values:

CompleteFailoverCluster

SQL Server Setup Control

/FAILOVERCLUSTERGROUP

Optional

Specifies the name of the resource group to be used for the SQL Server failover cluster. It can be the name of an existing cluster group or the name of a new resource group.

Default value:

SQLServer(<InstanceName>)

SQL Server Setup Control

/CONFIGURATIONFILE

Optional

Specifies the ConfigurationFile to use.

SQL Server Setup Control

/ERRORREPORTING

Optional

Specifies the error reporting for SQL Server.

For more information, see Privacy Statement for the Microsoft Error Reporting Service.

Supported values:

1=enabled
0=disabled

SQL Server Setup Control

/HELP, H, ?

Optional

Displays the usage options for the parameters.

SQL Server Setup Control

/INDICATEPROGRESS

Optional

Specifies that the verbose Setup log file will be piped to the console.

SQL Server Setup Control

/INSTANCENAME

Required

Specifies a SQL Server instance name.

For more information, see Instance Configuration.Instance Configuration

SQL Server Setup Control

/PID

Optional

Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.

SQL Server Setup Control

Optional

Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.

SQL Server Setup Control

/QS

Optional

Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.

SQL Server Setup Control

/SQMREPORTING

Optional

Specifies feature usage reporting for SQL Server.

For more information, see Privacy Statement for the Microsoft Error Reporting Service.

Supported values:

1=enabled
0=disabled

SQL Server Setup Control

/HIDECONSOLE

Optional

Specifies that the console window is hidden or closed.

SQL Server Setup Control

/FAILOVERCLUSTERDISKS

Required

Specifies the list of shared disks to be included in the SQL Server failover cluster resource group.

Default value:

The first drive is used as the default drive for all databases.

SQL Server Setup Control

/FAILOVERCLUSTERIPADDRESSES

Required

Specifies the list of IP addresses for the SQL Server failover cluster.

SQL Server Setup Control

/FAILOVERCLUSTERNETWORKNAME

Required

Specifies the network name for the new SQL Server failover cluster. This name is used to identify the new SQL Server failover cluster instance on the network.

Analysis Services

/ASBACKUPDIR

Optional

Specifies the directory for Analysis Services backup files.

Default values:

For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
For all other installations:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.

Analysis Services

/ASCOLLATION

Optional

Specifies the collation setting for Analysis Services.

Default value:

Latin1_General_CI_AS

Analysis Services

/ASCONFIGDIR

Optional

Specifies the directory for Analysis Services configuration files.

Default values:

For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.
For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.

Analysis Services

/ASDATADIR

Optional

Specifies the directory for Analysis Services data files.

Default values:

For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.
For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.

Analysis Services

/ASLOGDIR

Optional

Specifies the directory for Analysis Services log files.

Default values:

For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Log.
For all other installations: %Program Files%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Log.

Analysis Services

/ASSYSADMINACCOUNTS

Required

Specifies the administrator credentials for Analysis Services.

Analysis Services

/ASTEMPDIR

Optional

Specifies the directory for Analysis Services temporary files.

Default values:

For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
For all other installations: %Program Files%\Microsoft SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.

Analysis Services

/ASPROVIDERMSOLAP

Optional

Specifies whether the MSOLAP provider can run in-process.

Default value:

1=enabled

SQL Server Database Engine

/INSTALLSQLDATADIR

Required only if no shared disk is available

Specifies the data directory for SQL Server data files.

If INSTALLDATADIR is not specified and there are shared disks available, the first available shared disk is set as the data directory.

SQL Server Database Engine

/SAPWD

Required when /SECURITYMODE=SQL

Specifies the password for the SQL Server sa account.

SQL Server Database Engine

/SECURITYMODE

Optional

Specifies the security mode for SQL Server.

If this parameter is not supplied, then Windows-only authentication mode is supported

Supported values:

SQL Server Database Engine

/SQLBACKUPDIR

Optional

Specifies the directory for backup files.

Default value:

<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup.

SQL Server Database Engine

/SQLCOLLATION

Optional

Specifies the collation settings for SQL Server.

Default value:

SQL_Latin1_General_CP1_CS_AS

SQL Server Database Engine

/SQLSYSADMINACCOUNTS

Required

Use this parameter to provision logins to be members of the sysadmin role.

SQL Server Database Engine

/SQLTEMPDBDIR

Optional

Specifies the directory for the data files for tempdb.

Default value:

<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data.

SQL Server Database Engine

/SQLTEMPDBLOGDIR

Optional

Specifies the directory for the l files for tempdb.

Default value:

<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data

SQL Server Database Engine

/SQLUSERDBDIR

Optional

Specifies the directory for the data files for user databases.

Default value:

<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data

SQL Server Database Engine

/SQLUSERDBLOGDIR

Optional

Specifies the directory for the log files for user databases.

Default value:

<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data

SQL Server Database Engine

/USESYSDB

Optional

Specifies the location of the SQL Server system databases to use for this installation.

The path that is specified must not include the "\Data" suffix.

Reporting Services

/RSINSTALLMODE

Available on files only mode.

Specifies the Install mode for Reporting Services.

Sample Syntax:

To perform the "Completion" step of a failover cluster advanced installation scenario for the Database Engine and Analysis Services. Run the following command on the computer that will be the active node in the failover cluster to make it usable. You must run the "CompleteFailoverCluster" action on the node that owns the shared disk in the Analysis Services failover cluster.

Run the following command at the command prompt to complete failover cluster installation for a default instance:

setup.exe /q /ACTION=CompleteFailoverCluster /InstanceName=MSSQLSERVER /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\Username>" /ASDATADIR=<Drive>:\OLAP\Data /ASLOGDIR=<Drive>:\OLAP\Log /ASBACKUPDIR=<Drive>:\OLAP\Backup /ASCONFIGDIR=<Drive>:\OLAP\Config /ASTEMPDIR=<Drive>:\OLAP\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'>:" /FAILOVERCLUSTERNETWORKNAME="<Insert FOI Network Name>" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;Local Area Connection;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="MSSQLSERVER" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSYSADMINACCOUNTS="<DomainName\UserName>"

Run the following command at the command prompt to complete failover cluster installation for a named instance:

setup.exe /q /ACTION=CompleteFailoverCluster /InstanceName="<Insert Instance Name>" /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\UserName>" /ASDATADIR=<Drive>:\KATMAI\Data /ASLOGDIR=<drive>:\KATMAI\Log /ASBACKUPDIR=<Drive>:\KATMAI\Backup /ASCONFIGDIR=<Drive>:\KATMAI\Config /ASTEMPDIR=<Drive>:\KATMAI\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'>" /FAILOVERCLUSTERNETWORKNAME="CompNamedFOI" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;Local Area Connection;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="<Insert New Group Name>" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER_KATMAI" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSYSADMINACCOUNTS="<DomainName\Username>"

Upgrade Failover Cluster Parameters

Use the parameters in the following table to develop command-line scripts for failover cluster upgrade. cluster upgrade. For more information, see How to: Upgrade a SQL Server Failover Cluster Instance (Setup) and Getting Started with SQL Server 2008 Failover Clustering.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: Upgrade
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/ERRORREPORTING Optional	Specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/ INSTANCEDIR Optional	Specifies a nondefault installation directory for shared components.
SQL Server Setup Control	/INSTANCEID Required when you upgrade from SQL Server 2008 Optional when you upgrade from SQL Server 2000 and SQL Server 2005	Specifies a nondefault value for an InstanceID.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/SQMREPORTING Optional	Specifies feature usage reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
SQL Server Setup Control	/FAILOVERCLUSTERROLLOWNERSHIP	Specifies the failover behavior during upgrade.
SQL Server Browser Service	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for SQL Server Browser service Supported values: Automatic Disabled Manual
SQL Server Full-Text	/FTUPGRADEOPTION Optional	Specifies the Full-Text catalog upgrade option. Supported values: REBUILD RESET IMPORT
Integration Services	/ISSVCACCOUNT Required	Specifies the account for Integration Services. Default value: NT AUTHORITY\NETWORK SERVICE
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Integration Services	/ISSVCStartupType Optional	Specifies the startup mode for the Integration Services service.
Reporting Services	/RSUPGRADEDATABASEACCOUNT Optional
Reporting Services	/RSUPGRADEPASSWORD Optional

Add Node Parameters

Use the parameters in the following table to develop command-line scripts for AddNode.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate AddNode work flow. Supported value: AddNode
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration
SQL Server Setup Control	/PID Optional	Specifies the product key for the edition of SQL Server. If this parameter is not specified, SQL Server 2008 Enterprise Evaluation is used.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/QS Optional	Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
SQL Server Agent	/AGTSVCACCOUNT Required	Specifies the account for the SQL Server Agent service.
SQL Server Agent	/AGTSVCPASSWORD Required	Specifies the password for SQL Server Agent service account.
Analysis Services	/ASSVCACCOUNT Required	Specifies the account for the Analysis Services service.
Analysis Services	/ASSVCPASSWORD Required	Specifies the password for the Analysis Services service.
SQL Server Database Engine	/SQLSVCACCOUNT Required	Specifies the startup account for the SQL Server service.
SQL Server Database Engine	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT.
Integration Services	/ISSVCPASSWORD Required	Specifies the Integration Services password.
Reporting Services	/RSINSTALLMODE Available in Files only mode	Specifies the Install mode for Reporting Services.
Reporting Services	/RSSVCPASSWORD Required	Specifies the startup account password for the Reporting Services service.

Additional Notes:

The Database Engine and Analysis Services are the only components that are cluster-aware. Other features are not cluster-aware and do not have high availability through failover.

Sample Syntax:

To add a node to an existing failover cluster instance with the Database Engine and Analysis Services.

setup.exe /q /ACTION=AddNode /INSTANCENAME="<Insert Instance Name>" /SQLSVCACCOUNT="<SQL account that is used on other nodes>" /SQLSVCPASSWORD="<password for SQL account>" /AGTSVCACCOUNT="<SQL Server Agent account that is used on other nodes>", /AGTSVCPASSWORD="<SQL Server Agent account password>" /ASSVCACCOUNT="<AS account that is used on other nodes>" /ASSVCPASSWORD=”<password for AS account>” /INDICATEPROGRESS

Remove Node Parameters

Use the parameters in the following table to develop command-line scripts for RemoveNode. To uninstall a failover cluster, you must run RemoveNode on each failover cluster node. For more information, see Getting Started with SQL Server 2008 Failover Clustering.

SQL Server component	Parameter	Description
SQL Server Setup Control	/ACTION Required	Required to indicate RemoveNode work flow. Supported value: RemoveNode
SQL Server Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
SQL Server Setup Control	/HELP, H, ? Optional	Displays the usage options for the parameters.
SQL Server Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file will be piped to the console.
SQL Server Setup Control	/INSTANCENAME Required	Specifies a SQL Server instance name. For more information, see Instance Configuration.Instance Configuration.
SQL Server Setup Control	/Q Optional	Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
SQL Server Setup Control	/QS Optional	Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.

Sample Syntax:

To remove a node from an existing failover cluster instance with the Database Engine and Analysis Services.

setup.exe /q /ACTION=RemoveNode /INSTANCENAME="<Insert Instance Name>" [/INDICATEPROGRESS]

Parameters from Previous SQL Server Versions

Use the following table to find supported parameter mapping from the previous SQL Server versions.

SQL Server 2005	Supported in SQL Server 2008	Replacement Parameter in SQL Server 2008	Comments
/QB	No	/QS will be supported
/QN	No
/ADDLOCAL	No	/ACTION=Install and /FEATURES
/ADDNODE	No		To add a node to SQL Server 2008 cluster, run setup on the node to be added and specify "new" AddNode action.
/ADMINPASSWORD	No		SQL Server 2008 cluster setup does not support remote deployment.
/AGTACCOUNT	Yes	/AGTSVCACCOUNT
/AGTAUTOSTART	Yes	/AGTSVCSTARTUPTYPE
/AGTCLUSTERGROUP	Yes	/AGTDOMAINGROUP
/AGTPASSWORD	Yes	/AGTSVCPASSWORD
/ASACCOUNT	Yes	/ASSVCACCOUNT
/ASAUTOSTART	Yes	/ASSVCSTARTUPTYPE
/ASCOLLATION	Yes
/ASPASSWORD	Yes	/ASSVCPASSWORD
/DISABLENETWORKPROTOCOLS	No
/ERRORREPORTING	Yes
/ENABLERANU	Yes
/FTSCLUSTERGROUP	No		FTS changes to IFTS for SQL Server 2008 as part of SQL Server Database Engine. You do not have to have a separate IFTS group.
/GROUP	Yes	/FAILOVERCLUSTERGROUP
/INSTALLASDATADIR	Yes	/ASDATADIR
/INSTALLSQLDATADIR	No	/SQLUSERDBDIR /SQLUSERDBLOGDIR /SQLBACKUPDIR /SQLTEMPDBDIR /SQLTEMPDBLOGDIR
/INSTALLSQLDIR	Yes	/INSTANCEDIR
/INSTALLSQLSHAREDDIR	Yes	/InstallShareDir32 /InstallShareDir64
/INSTALLVS	No	/FEATURES	Features that can be clustered: Analysis Services SQL Server Database Engine
/INSTANCENAME	Yes
/IP	Yes	/FAILOVERCLUSTERIPADDRESSES
/ISACCOUNT	Yes	/ISSVCACCOUNT
/ISPASSWORD	Yes	/ISSVCPASSWORD
/ISAUTOSTART	Yes	/ISSVCSTARTUPTYPE
/PIDKEY	Yes	/PID
/REBUILDDATABASE	No	/ACTION	Use /ACTION=RebuildDatabase
/REINSTALL	No
/REINSTALLMODE	No
/REMOVE	No	/ACTION and /FEATURES
/REMOVENODE	No		To remove a node from SQL Server 2008 cluster, run Setup on the node to be removed and specify the RemoveNode action.
/RSACCOUNT	Yes	/RSSVCACCOUNT
/RSAUTOSTART	Yes	/RSSVCSTSRTUPTYPE
/RSCONFIGURATION	Yes	/RSINSTALLMODE
/RSPASSWORD	Yes	/RSSVCPASSWORD
/SAMPLEDATABASE	No
/SAPWD	Yes
/SAVESYSDB	Yes
/SECURITYMODE	Yes
/SKUUPGRADE	No	/ACTION and /FEATURES
/SQLACCOUNT	Yes	/SQLSVCACCOUNT
/SQLAUTOSTART	Yes	/SQLSVCSTARTUPTYPE
/SQLBROWSERACCOUNT	Yes	/BROWSERSVRACCOUNT
/SQLBROWSERPASSWORD	Yes	/BROWSERSVRPASSWORD
/SQLBROWSERAUTOSTART	Yes	/BROWSERSVRSTARTUPTYPE
/SQLCLUSTERGROUP	Yes	/SQLDOMAINGROUP
/SQLCOLLATION	Yes
/SQLPASSWORD	Yes	/SQLSVCPASSWORD
/UPGRADE	No	/ACTION and /FEATURES
/USESYSDB	Yes
/VS	Yes	/FAILOVERCLUSTERNETWORKNAME
/RSUpgradeDatabase	Yes	/RSUpgradeDatabase
/RSUpgradePassword	Yes	/RSUpgradePassword

Service Account Parameters

You can configure the SQL Server 2008 services by using a built-in account, local account, or domain account.

Note:
When you use a built-in account, you should not specify the corresponding password parameters.

For more information about service account configuration, see SQL Server Configuration - Service Accounts and Setting Up Windows Service Accounts.

SQL Server component	Account parameter	Password parameter	Startup type
SQL Server Agent	/AGTSVCACCOUNT	/AGTSVCPASSWORD	/AGTSVCSTARTUPTYPE
Analysis Services	/ASSVCACCOUNT	/ASSVCPASSWORD	/ASSVCSTARTUPTYPE
SQL Server Database Engine	/SQLSVCACCOUNT	/SQLSVCPASSWORD	/SQLSVCSTARTUPTYPE
Integration Services	/ISSVCACCOUNT	/ISSVCPASSWORD	/ISSVCSTARTUPTYPE
Reporting Services	/RSSVCACCOUNT	/RSSVCPASSWORD	/RSSVCSTARTUPTYPE

Feature Parameters

To install specific features, use the /FEATURES parameter and specify the parent feature or feature values in the following table.

Parent feature parameter	Feature parameter	Description
SQL		Installs the SQL Server Database Engine, Replication, and Fulltext components.
	SQLEngine	Installs just the SQL Server Database Engine.
	Replication	Installs the Replication component. The SQLEngine value has to be specified with this value.
	FullText	Installs the FullText component. The SQLEngine value has to be specified with this value.
AS		Installs all Analysis Services components.
RS		Installs all Reporting Services components.
IS		Installs all Integration Services components.
Tools		Installs client tools and SQL Server Books Online.
	BC	Installs backward compatibility components.
	BOL	Installs SQL Server Books Online.
	BIDS	Installs Business Intelligence Development Studio.
	Conn	Installs connectivity components.
	SSMS	Installs SQL Server Management Tools – Basic. This includes the following: SQL Server Management Studio support for the SQL Server Database Engine, SQL Server Express, sqlcmd utility, and the SQL Server PowerShell provider
	ADV_SSMS	Installs SQL Server Management Tools – Complete. This includes the following components in addition to the components in the Basic version: SQL Server Management Studio support for Reporting Services, Analysis Services, and Integration Services SQL Server Profiler Database Engine Tuning Advisor
	SDK	Installs the software development kit.

Feature parameter examples:

Parameter and values	Description
/FEATURES=SQLEngine	Installs the Database Engine without replication and full-text.
/FEATURES=SQLEngine, FullText	Installs the Database Engine and full-text.
/FEATURES=SQL, Tools	Installs the complete Database Engine and all tools.
/FEATURES=BOL	Installs SQL Server Books Online.

Instance ID or InstanceID Configuration

The Instance ID or /InstanceID parameter is used for specifying where you can install the instance components and the registry path of the instance. The value of “INSTANCEID” is a string and should be unique.

SQL Instance ID:MSSQL10.<INSTANCEID>
AS Instance ID:MSAS10.<INSTANCEID>
RS Instance ID:MSRS10.<INSTANCEID>

The instance-aware components are installed to the following locations:

%Program Files%\Microsoft SQL Server\<SQLInstanceID>

%Program Files%\Microsoft SQL Server\<ASInstanceID>

%Program Files%\Microsoft SQL Server\<RSInstanceID>

Note:
If INSTANCEID is not specified on the command line, then by default Setup substitute <INSTANCEID> with the <INSTANCENAME>.

Controlling Failover Behavior using the /FAILOVERCLUSTERROLLOWNERSHIP Parameter

To upgrade a SQL Server failover cluster to SQL Server 2008, you must run the Setup on one failover cluster node at a time, starting with the passive nodes. Setup determines when to fail over to the upgraded node, depending on the total number of nodes in the failover cluster instance, and the number of nodes that have already been upgraded. When half of the nodes or more have already been upgraded, Setup by default will cause a failover to an upgraded node.

To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter to control the failover behavior before the upgrade operation takes the node offline. Use of this parameter is as follows:

/FAILOVERCLUSTERROLLOWNERSHIP=0 will not roll cluster ownership (move group) to upgraded nodes, and does not add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
/FAILOVERCLUSTERROLLOWNERSHIP=1 will roll cluster ownership (move group) to upgraded nodes, and will add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
/FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. It will be used if this parameter is not specified. This setting indicates that SQL Server Setup will manage cluster ownership (move group) as needed.

Tags

: (then (x) /usesysdb (x) 2008 (x) 2008. (x) a (x) according (x) an (x) article (x) as (x) attempts (x) be (x) been (x) but (x) caused (x) exception (x) found (x) from (x) had (x) has (x) here (x) http://msdn.microsoft.com/en-us/library/dd239405.aspx (x) installation (x) is (x) it (x) listed (x) not (x) option (x) our (x) parameter (x) recognized. (x) removed (x) removed.) (x) Add a tag

Community Content

Add new content

Annotations

Brower Service Account and Password

geertDCOD | Edit | Show History

I'm missing options to specify the Brower Service Account and Password at installation from command prompt

Tags

: 2008 (x) command-line (x) Add a tag

Flag as ContentBug

see the install command line for full feature install

Kajol Kareena | Edit | Show History

[Tai Yee - MSFT] - see the install command line for full feature install, which included the browser account parameters= /SQLBROWSERACCOUNT ="DomainName\UserName" /SQLBROWSERPASSWORD= "StrongPassword"

Tags

: Add a tag

Flag as ContentBug

Sample for upgrading is incorrect

Patrick68 | Edit | Show History

The sample given for upgrading an instance from SQL Server 2000 or 2005 is not correct. Parameter /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" is not supported in combination with /ACTION=Upgrade.

Tags

: contentbug (x) Add a tag

Ignore INSTALLSHAREDWOWDIR when installing on x86 platform

Eric-Jan | Edit | Show History

This entry is in the ConfigurationFile.ini (together with INSTALLSHAREDDIR). The DVD (SP1 slipstreamed) is for x64 and x86 (like the original). When installing on x64 everything works fine. The x86 installation however terminates stating the INSTALLSHAREDWOWDIR is only for x64 platforms instead of ignoring it.

Tags

: Add a tag

Flag as ContentBug

/qs Valid Parameter For Uninstall Also

M. Card | Edit | Show History

The documentation does not mention this but /qs is also a valid uninstall parameter. It does the same thing as install: showing progress through the UI but not accepting any input.

Tags

: contentbug (x) Add a tag

Installing SQL Server 2008 SP1 from command prompt

Prashant Thakwani ... slimgoody | Edit | Show History

Hello,

Could you please give the examples to install SP1 from comamnd prompt ? I tried with switch "Action" with values "*INSTALL" and "UPGRADE" and get the non-supported eror with "Action".

RE: Try /Action=Patch /instancename=InstanceName (for the instance name)

Tags

: contentbug (x) Add a tag

Upgrade to SP1 using command line

ASMNIT | Edit | Show History

To upgrade to SP1 using command line, I used setup.exe /ACTION=Upgrade /AllInstances /IndicateProgress and it worked.

Tags

: Add a tag

Flag as ContentBug

/USESYSDB option not available

slh1234 | Edit | Show History

According to http://msdn.microsoft.com/en-us/library/dd239405.aspx, the USESYSDB has been removed for SQL 2008, but it is still listed as an option here. Attempting to use it gives this error:

xception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException
Message:
The setting 'USESYSDB' specified is not recognized.
Data:
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveParsedArgumentsIntoInputSettingStore(InputSettingSource source, Dictionary`2 parsedArguments, Boolean chainerSetting, Boolean ignoreSettingsForNotAllowedScnearios)
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.ProcessCommandLineArguments(String[] commandLineArguments, Boolean chainerSetting)
at Microsoft.SqlServer.Configuration.BootstrapExtension.ProcessChainerCommandLineArgumentsAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

So it seems that, in fact, USESYSDB is not available for SQL 2008 installations.

Tags

: Add a tag

Flag as ContentBug

Sample Syntax:

Sample Syntax:

Sample Syntax:

Sample Syntax:

Integrated Install Failover Cluster Parameters

Additional Notes:

Sample Syntax:

Prepare Failover Cluster Parameters

Sample Syntax:

Complete Failover Cluster Parameters

Sample Syntax:

Upgrade Failover Cluster Parameters

Add Node Parameters

Additional Notes:

Sample Syntax:

Remove Node Parameters

Sample Syntax:

Feature parameter examples:

Instance ID or InstanceID Configuration

Controlling Failover Behavior using the /FAILOVERCLUSTERROLLOWNERSHIP Parameter

Tasks

Concepts

Help and Information