B.7 Silently Installing the CCDB

The procedure for silently installing the CCDB differs from the procedure for silently installing other components. To silently install the CCDB, you create an initialization file that records the variables to use during the installation, and then execute a command that reads the variables in the file to install the CCDB.

You can silently install CCDBs to remote SQL Servers. You do not have to run the installation on the SQL Server.

To silently install the CCDB:

  1. On the computer where you saved the AppManager installation files, copy the ccdbinstall.iss file from the Setup Files folder to the folder in which you will create the initialization file.

  2. In the folder where you copied ccdbinstall.iss, create a response file named silent.ini with the appropriate parameters.

    The following table describes the parameters available for silently installing the CCDB. When you add the parameters to the silent.ini file, follow the order in the table.

    Parameter

    Description and Values

    RP_UPGRADE

    If the CCDB specified for the RP_NAME parameter already exists, whether to upgrade the existing CCDB

    Specify FALSE if you do not want to upgrade the existing CCDB.

    Specify TRUE if you want to upgrade the existing CCDB.

    If you do not specify the RP_UPGRADE parameter and the CCDB already exists, the CCDB will not be upgraded.

    RP_CLEARTEXTPASSWORD

    Indicates the silent.ini file will submit passwords to the Windows Installer package in clear text format

    Specify 1 to use clear text format for passwords.

    This parameter is required for successful installation. If you do not include this parameter, the Windows Installer package will attempt to decrypt passwords and you will receive the following error message:

    Failed to decrypt the input data with FIPS compliant algorithms.

    RP_SQLSERVER

    Name of the SQL Server and, if applicable, instance that will host the CCDB

    To specify a SQL Server instance, use the format Server_Name\instance.

    RP_NAME

    Name of the CCDB

    RP_WINDOWSAUTH

    Whether to use the current Windows user account or a SQL Server user account to log in to the SQL Server to create the CCDB

    Specify 1 to use the current Windows user account to log in to the SQL Server to create the CCDB.

    Specify 0 to use a SQL Server user account to log in to the SQL Server to create the CCDB. If you specify 0, specify values for the RP_SQLUSER and RP_SQLPWD parameters.

    For more information about the account, see Reviewing Required Accounts and Permissions.

    RP_SQLUSER

    User name for the SQL Server user account that will log in to the SQL Server to create the CCDB

    RP_SQLPWD

    Password for the SQL Server user account that will log in to the SQL Server to create the CCDB

    RP_DATAPATH

    Location of the data file associated with the CCDB

    If you do not specify this parameter, the default value is the root folder for Microsoft SQL Server. For example, C:\Program Files\Microsoft SQL Server\MSSQL10\MSSQL\Data.

    Ensure the folder exists before you start the installation.

    RP_DATASIZE

    Initial size of the data file associated with the CCDB

    The minimum required value is 512 MB. The default value is 1024 MB.

    If you do not specify this parameter, the default value is used.

    The autogrowth rate for the file is set to 256 MB. Allow at least enough free space to accommodate the autogrowth rate.

    RP_DATANAME

    Name of the data file associated with the CCDB, without the file type extension. For example, NQCCDBData.

    RP_LOGPATH

    Location of the log file associated with the CCDB

    If you do not specify this parameter, the default value is the root folder for Microsoft SQL Server. For example, C:\Program Files\Microsoft SQL Server\MSSQL10\MSSQL\Data.

    Ensure the folder exists before you start the installation.

    RP_LOGNAME

    Name of the log file associated with the CCDB, without the file type extension. For example, NQCCDBLog.

    RP_LOGSIZE

    Initial size of the log file associated with the CCDB

    The minimum required value is 50 MB. The default value is 512 MB.

    If you do not specify this parameter, the default value is used.

    The autogrowth rate for the file is set to 256 MB. Allow at least enough free space to accommodate the autogrowth rate.

    RP_WINREPOWNER

    Whether the account that will own the CCDB will be a Windows user account or a SQL Server user account

    Specify 1 to use a Windows user account. If you specify 1, specify a value for the RP_OWNER parameter.

    Specify 0 to use a SQL Server user account. If you specify 0, specify values for the RP_OWNER and RP_OWNERPWD parameters.

    For more information about the account, see Reviewing Required Accounts and Permissions.

    RP_OWNER

    User name for the account that will own the CCDB.

    If the account is a Windows user account, specify the name in domain\User_Name format.

    RP_OWNERPWD

    If the CCDB owner is a SQL Server user account, password for the account.

    RP_CQSUSERDOMAIN

    Domain and user name for the Windows user account the command queue service will use to connect to the CCDB

    For more information about the account, see Reviewing Required Accounts and Permissions.

    RP_ADSUSERDOMAIN

    Domain and user name for the Windows user account the Deployment Service will use to connect to the CCDB

    For more information about the account, see Reviewing Required Accounts and Permissions.

  3. Run the following command from the folder where you saved the CCDB setup program:

    "Full_Path_to_Setup_Files_Folder\
    NetIQ Control Center Repository Installation.exe" /s 
    /f1"Full_Path_to_ccdbinstall.iss_File" 
    -silentinstall="Full_Path_to_silent.ini_File"

    Ensure that you do not include a space between /f1 and "Full_Path_to_ccdbinstall.iss_File". The installation will fail if you include a space.

For more information about installing the CCDB, see Section 7.0, Installing Control Center Components.