# SQL Server 2000 (64-bit) Setup Command

SQL Server 2000

This topic applies only to SQL Server 2000 (64-bit).

The Microsoft® SQL Server™ 2000 (64-bit) Setup.exe program provides a command line interface in addition to the graphical user interface provided when Setup is run from My Computer or Windows Explorer. Use the properties described in this topic to define settings for customizing the way Setup.exe installs SQL Server 2000. These property settings can be specified either on the command line or in an .ini file specified by the /settings argument.

Important  For all path-related parameters in setup, use of a trailing backslash (\) is required.

The following syntax shows the three different command lines to show help, to install an instance, or to remove an instance.

##### Syntax

setup /?

setup

[/i package_file]
{/settings ini_file | property1=setting1 property2=setting2 ...}
[{/qn|/qb}]

[/l*v log_file]

setup /x package_file
[/qn

[/l*v log_file]

##### Arguments

/?

Displays a syntax summary of the setup switches.

/i package_file

This argument is not required to install a new instance. It specifies the name of the Microsoft Windows® installation package file (an .msi file) to be used to install an instance of SQL Server 2000 or any of its features. You should specify the complete path to the file following the /i or /x switch. Place the .msi file in the same folder as Setup.exe. Msi files are located in the setup subdirectory from the root directory of the CD. If this parameter is omitted, Setup automatically chooses the next unused .msi file for the installation. For maintaining an existing installation you can instead specify the product code from the ProductCode registry key. For the default instance, use HKEY_Local_Machine\Software\Microsoft\MSSQLServer\Setup:ProductCode. For a named instance, use HKEY_Local_Machine\Software\Microsoft SQL Server\instancename\Setup:ProductCode.

To uninstall a failover cluster, do not use this argument. Use the NODELIST property with an empty list.

/settings ini_file

Specifies the name of an .ini file containing settings for the Setup Properties (listed later in this topic). Place the .ini file in the same folder as Setup.exe. If you use this argument, properties should be set in the .ini file, not in the setup command line. For more information, see Specifying Setup Properties with an .ini File (64-bit).

property1=setting1 property2=setting2 ...

Sets a value for a setup property, which may have a string or a value setting. You only need to include the property settings that are required for an installation. The properties and their settings are described later in this topic. Spaces are permitted in a character string setting but the string must then be enclosed between double quotation marks: "string". For any double quotation character included within the string setting, you must place an additional double-quotation character ("") as an escape code. End paths for folder locations with a backward slash:

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


If the /settings argument is used to specify an .ini file, properties should be set in the .ini file, not on the setup command line.

/x package_file

Specifies the Windows Installer installation package file (an .msi file) to use when uninstalling an instance of SQL Server 2000. You must specify the name of the same installation package file that was used to install the instance of SQL Server. Specify the complete path to the file following the /x switch.

/qn

In order to perform an unattended installation, you must specify either /qn or /qb. The /qn switch specifies that Setup run with no user interface. This argument is required for unattended failover cluster installations.

/qb

In order to perform an unattended installation, you must specify either /qn or /qb. This argument specifies that Setup show only the basic user interface. Only dialog boxes displaying progress information are displayed.

This argument cannot be used for failover cluster installations.

/l*v log_file

Specifies that the verbose log be created. If this argument is omitted, a non-verbose log is created and saved in the %TEMP% location as Sqlrunn.log (where n represents an enumeration for the installation). Another log, Sqlstpn.log is always created for every installation in the %TEMP% location.

##### Properties

Specifies the features to be installed with the current instance either for a new instance or for maintaining an existing instance. The feature_selection list is a comma-delimited list composed of the following features:

Feature Description
SQL_Server,
SQL_Tools,
SQL_Engine,
SQL_Replication,
SQL_Data_Files,
SQL_DevTools
SQL Server features that are all required when you install SQL Server.
SQL_FullText Full-text search engine.
AnalysisServices,
Analysis_Server,
AnalysisDataFiles,
AnalysisSQL,
AnalysisSQLData,
AnalysisClient
Analysis Services features that are all required when you install Analysis Services.
Books_Online Books Online.

If ADDLOCAL is omitted, Setup performs a complete installation of all features. If adding features to an existing installation, specify only those features that you are adding. For example, to add Analysis Services to an existing installation, specify the following property setting:

ADDLOCAL=SqlRun,AnalysisServices,Analysis_Server,AnalysisDataFiles,AnalysisSQL,AnalysisSQLData,AnalysisClient


This property is not used to install the SQL Server 2000 Desktop Engine.

This property cannot be used for failover cluster installations.

AGTACCOUNT="domain\logon_name"

Specifies the SQL Server Agent service account domain and logon name. Use AGTPASSWORD to specify the password that corresponds to the logon name. The default if this property is omitted is the local system account.

This property is required for failover cluster installations.

Specifies the SQL Server Agent service account password that corresponds to the logon name specified by AGTACCOUNT.

This property is required for failover cluster installations.

Caution  If this property is omitted, the sa password will be set to NULL. Microsoft recommends that you use Windows Authentication security mode (integrated security). If you must use SQL Server Authentication, you should immediately change the password.

AGTAUTOSTART={1|0}

Specifies whether the SQL Server Agent service is started automatically when the Microsoft Windows® operating system is restarted. Specify 1 to enable or 0 to disable automatic restart. The default if this property is omitted is 1. The SQL Server Agent service requires the SQL Server service to start, so if you specify 1 for this property then the SQLAUTOSTART property setting is also set to 1 (even if you specify SQLAUTOSTART=0).

BLANKSAPWD=1

Specifies that the sa password should be set to NULL. The password string specified by this property is hidden and not written to the log file.

CALLBACK=Dllname!CallbackFunctionName

Specifies the name of the DLL containing the Windows Installer callback function, as well as the name of the callback function.

COLLATION="collation_designator"

Specifies the SQL Server collation that will be used as the default collation for this instance of SQL Server. The default collation depends on the Windows locale setting. For a list of Windows locales and their corresponding collation designators, see the "Windows Collation Designators" topic in SQL Server 2000 32-bit Books Online. (64-bit)

COMPANYNAME="company_name"

Specifies the name for the company registering this product. If this property is omitted, the company name for the operating system is used. If the name contains any spaces, enclose it between double quotation marks.

INSTALLOLAPDIR="OLAP_executable_folder_path"

Specifies the folder where the Analysis Services executable files are installed. The default path is systemdrive\Program Files\Microsoft Analysis Services\. For all path-related parameters, use of a trailing backslash (\) is required. Install Analysis Services to a folder that uses only single-byte characters in the path and name.

This property cannot be used for failover cluster or MSDE installations.

Specifies the folder where the Analysis Services cubes are built. The default path is systemdrive\Program Files\Microsoft Analysis Services\Data\.

This property cannot be used for failover cluster or MSDE installations.

INSTALLSQLDIR="SQL_executable_folder_path"

Specifies the folder where the SQL Server executable files are installed. The default path is systemdrive\Program Files\Microsoft SQL Server\. SQL Server then locates program files for the default instance in systemdrive\Program Files\Microsoft SQL Server\MSSQL. For a named instance, it locates program files in systemdrive\Program Files\Microsoft SQL Server\MSSQL$instancename. For installation of a failover cluster, this property is required, and SQL_executable_folder_path must be located on a local drive with a drive letter that exists on all nodes in the cluster definition. INSTALLSQLDATADIR="data_folder_path" Specifies the folder where the SQL Server system databases are built. The default path is systemdrive\Program Files\Microsoft SQL Server\. SQL Server then locates database files for the default instance in systemdrive\Program Files\Microsoft SQL Server\MSSQL\Data. For a named instance, it locates program files in systemdrive\Program Files\Microsoft SQL Server\MSSQL$instancename\Data.

For installation of a failover cluster, this property is required, and data_folder_path must be located on shared drive that is a member of the cluster group specified for installation (see the GROUP property).

INSTANCENAME="instance_name"

Specifies the name of the instance. If this property is omitted, the instance is installed as a default instance. See Naming Instances (64-bit) for complete rules to name an instance.

This property is optional for failover cluster installations. If you want to assign an instance name to your cluster installation, then include this property setting.

PIDKEY=cd_key

Specifies the 25-character product identification key required for installation of SQL Server 2000. You can find this number on the yellow sticker in the installation CD liner notes or on the CD case. This property is required.

This property is not used to install the SQL Server 2000 Desktop Engine.

OLAPACCOUNT="domain\logon_name"

Specifies the MSSQLServerOLAPService service account domain and logon name. Use OLAPPASSWORD to specify the password that corresponds to the logon name. The default if this property is omitted is the local system account.

This property is not used to install the SQL Server 2000 Desktop Engine.

This property cannot be used for failover cluster installations.

OLAPAUTOSTART={1|0}

Specifies whether the MSSQLServerOLAPService service is started automatically when the Windows operating system is restarted. Specify 1 to enable or 0 to disable automatic restart. The default if this property is omitted is 1.

This property is not used to install the SQL Server 2000 Desktop Engine.

This property cannot be used for failover cluster installations.

Specifies the MSSQLServerOLAPService service account password that corresponds to the logon name specified by OLAPACCOUNT.

This property is not used to install the SQL Server 2000 Desktop Engine.

This property cannot be used for failover cluster installations.

Caution  If this property is omitted, the sa password will be set to NULL. Microsoft recommends that you use Windows Authentication security mode (integrated security). If you must use SQL Server Authentication, you should immediately change the password.

Specifies the number of per processor licenses purchased. If you use the PERPROCESSOR property, do not use the PERSEAT property.

This property is not used to install the SQL Server 2000 Desktop Engine.

Specifies the number of per seat licenses purchased. If you use the PERSEAT property, do not use the PERPROCESSOR property.

This property is not used to install the SQL Server 2000 Desktop Engine.

REINSTALL=All

Specifies that Setup install all previously installed SQL Server 2000 (64-bit) features. The only value supported is All. This property must always be used with REINSTALLMODE.

REINSTALLMODE={omus|amus}

Specifies the level of processing performed by Setup. Use REINSTALLMODE=omus when resuming a failed setup. With this option, the entire installation is verified and completed. REINSTALLMODE=omus also rebuilds the registry for a corrupted Microsoft SQL Server installation. Use REINSTALLMODE=amus to rebuild the system databases (for example, to change the server collation or to rebuild the master database after a hard drive failure). When you use REINSTALLMODE=amus, you can modify the security settings (SECURITY and SAPWD) and the collation (COLLATION).

REMOVE="feature_selection"

Specifies the features that will be removed from an existing installation. The feature_selection list is a comma-delimited list containing features listed under ADDLOCAL. To completely remove an instance, use the /x argument on the setup command line.

This property cannot be used for failover cluster installations.

Specifies the sa password when you use the SECURITYMODE=SQL property. The password string specified by this property is hidden and not written to the log file.

Caution  If this property is omitted, the sa password will be set to NULL. Microsoft recommends that you use Windows Authentication security mode (integrated security). If you must use SQL Server Authentication, you should immediately change the password.

SECURITYMODE=SQL

Configures the installed instance to use SQL Server (Mixed Mode) Authentication. The default if you omit this property is to use Windows Authentication and place the Windows local Administrators group in the SQL Server sysadmin fixed server roll. When you use this property, you can use SAPWD to specify the sa password for SQL Server Authentication.

Note   Microsoft recommends that you use Windows Authentication security mode (integrated security). If you must use SQL Server Authentication, you should immediately change the password

SQLACCOUNT="domain\logon_name"

Specifies the SQL Server service account domain and logon name. Use SQLPASSWORD to specify the password that corresponds to the logon name. The default if this property is omitted is the local system account.

This property is required for failover cluster installations.

SQLAUTOSTART={0|1}

Specifies whether the SQL Server service is started automatically when the Windows operating system is restarted. Specify 1 to enable or 0 to disable automatic restart. The default if this property is omitted is 1.

Specifies the SQL Server service account password that corresponds to the logon name specified by SQLACCOUNT.

This property is required for failover cluster installations.

Caution  If this property is omitted, the sa password will be set to NULL. Microsoft recommends that you use Windows Authentication security mode (integrated security). If you must use SQL Server Authentication, you should immediately change the password.

Specifies that Windows Installer is upgrading the instance specified by INSTANCENAME. If INSTANCENAME is not specified, then the default instance is upgraded. The only supported value is 1.

Note  Upgrades are not supported for this release of SQL Server 2000 (64-bit).

This property is not used to install the SQL Server 2000 Desktop Engine.

Specifies that Setup connect to the instance using SQL Server Authentication using the specified login account. The login account must be a member of the sysadmin fixed server role.

It is recommended that you not use this property, so that Setup uses Windows Authentication to connect to the instance. Omitting this property requires Setup to run under a Windows domain or computer account that has been included in the SQL Server sysadmin fixed server role.

This property is not used to install the SQL Server 2000 Desktop Engine.

Specifies the name for the user registering this product. If this property is omitted, the user name for the operating system is used. If the name contains any spaces, enclose it between double quotation marks.

###### Cluster Specific Properties

Specifies the domain and the administrator account name that is used to spawn processes to remote nodes during Setup only. This account must be a valid administrator on all nodes in the cluster. This property is optional only if the only node affected is the node on which Setup is being run.

GROUP="cluster_group_name"

Specifies the cluster group name. This is the group that contains the disk to which the shared data files are written and that contains SQL Server resources. The node that owns the cluster group must be specified by the NODELIST property.

Specify one or more IP addresses that are used to connect to each virtual server. Only one address per network adaptor is permitted, although this property can be used multiple times, once for each network adaptor.

NODELIST="node1_name,node2_name"

Specifies the cluster nodes that are part of the virtual server definition. This list is comma-delimited. To add a node to an existing virtual server definition, execute the original command line or .ini file with the new node added to the NODELIST property setting. To remove a node from an existing virtual server definition, execute the original command line or .ini file with the node removed from the NODELIST property setting. To uninstall a cluster, simply provide an empty NODELIST or omit the NODELIST property completely.

VS="virtual_server_name"

Specifies the name of the virtual server. This is the name that users see when they connect to the virtual server. For more information, see Creating a Failover Cluster (64-bit). This name must be 15 characters or less and follow the naming rules for a computer name.