Command Prompt Option /qb in C#.NET

Drawer GS1 - 13 in C#.NET Command Prompt Option /qb

8

Table 8-5

Command Prompt Installation Options (continued)

Description This parameter specifies the name of the instance. MSSQLSERVER is used to represent the default instance. This parameter must be specified for instance-aware components. This parameter is used to specify which product to upgrade. The INSTANCENAME parameter must be used in conjunction with this parameter. This parameter can be used during uninstall to specify not to delete system databases. This parameter is used to specify the root path to the system databases data directory during upgrade. These parameters are used to specify the service accounts and passwords for the services. A service account and password need to be provided for each service selected for installation. These parameters are used to specify the startup behavior of the respective service. When set to 1, the service will start automatically; when set to 0, the service must be started manually. SECURITYMODE=SQL is used to specify mixed mode authentication. SAPWD is used to specify the password for the sa account. These parameters are used to set the collations for SQL Server and Analysis Services, respectively. This parameter is used to rebuild the master database. This parameter is used to repair installed components that may be corrupted. This parameter is used to specify the components to reinstall and must be specified when using REINSTALLMODE. REINSTALL parameters use the same values as ADDLOCAL parameters. This parameter is applicable only if Reporting Services or Report Manager is installed. It is used to specify whether to configure the service. This parameter is used to specify the server and instance name to which the sample databases should be attached.

SAVESYSDB USESYSDB SQLACCOUNT, SQLPASSWORD, AGTACCOUNT, AGTPASSWORD, ASACCOUNT, ASPASSWORD, RSACCOUNT, RSPASSWORD SQLBROWSERAUTOSTART, SQLAUTOSTART, AGTAUTOSTART, ASAUTOSTART, RSAUTOSTART SECURITYMODE and SAPWD

Table 8-5

Command Prompt Installation Options (continued)

Description This parameter is used to set up the start-up state of the network protocols. This parameter is used to configure SQL Server to send reports from any fatal errors directly to Microsoft.

the SQL Server Setup Help by double-clicking <DVD Drive>\Servers\Setup\help\1033\setupsql9.chm and searching for How to: Install SQL Server 2005 from the Command Prompt .

In the next few sections, we will see how these parameters can be used in combination to perform a variety of operations such as installing a default instance with all the components, installing a named instance with mixed mode authentication, adding components to an existing instance, and using a settings file to pass in the installation parameters.

This is one of the most commonly used command prompt based installation scenarios. The following command installs all of the SQL Server 2005 components in a default instance (MSSQLSERVER) on the local server. A Windows administrator account called advadmin with a password of Pa55wD is used for all the services.

start /wait <DVD Drive>\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SAPWD=Pa55wD SQLACCOUNT=advadmin SQLPASSWORD=Pa55wD AGTACCOUNT=advadmin AGTPASSWORD=Pa55wD ASACCOUNT=advadmin ASPASSWORD=Pa55wD RSACCOUNT=advadmin RSPASSWORD=Pa55wD SQLBROWSERACCOUNT=advadmin SQLBROWSERPASSWORD=Pa55wD

Best Practices If you plan to store these commands as script files, you should make sure to store them in a secure location with the correct permissions, since they contain unencrypted passwords.

The following command installs database engine and management tools components on a named instance of SQL Server 2005 called SS2K5 with mixed authentication and the

8

Latin1_General_BIN collation. A Windows administrator account called advadmin with a password of Pa55wD is used for all the services.

start /wait <DVD Drive>\Servers\setup.exe /qb INSTANCENAME=SS2K5 ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity,SQL_Tools9 0 SECURITYMODE=SQL SQLCOLLATION=Latin1_General_Bin SQLAUTOSTART=1 AGTAUTOSTART=1 SAPWD=Pa55wD SQLACCOUNT=advadmin SQLPASSWORD=Pa55wD AGTACCOUNT=advadmin AGTPASSWORD=Pa55wD SQLBROWSERACCOUNT=advadmin SQLBROWSERPASSWORD=Pa55wD

The command prompt installation method can also be used to add components to an existing SQL Server 2005 instance. The following command adds the Analysis Server components with the Latin1_General_Bin collation setting to an existing instance named SS2K5. Once again, a Windows administrator account called advadmin with a password of Pa55wD is used for all the services.

start /wait <DVD Drive>\Servers\setup.exe /qb INSTANCENAME=SS2K5 ADDLOCAL=Analysis_Server,AnalysisDataFiles ASCOLLATION=Latin1_General_Bin SAPWD=Pa55wD ASACCOUNT=advadmin ASPASSWORD=Pa55wD