This section describes the steps required to install the QDB on local and remote SQL Servers.
To install the QDB:
Ensure the accounts required to install the QDB are properly configured.
For more information about the required accounts, see Reviewing Required Accounts and Permissions.
Complete the steps in Understanding the AppManager Pre‑Installation Check.
After you view the pre-installation check report, click Next to start the installation.
When you reach the Target SQL Server and Repository Name window, provide the following information and then click Next:
Name of the SQL Server and, if applicable, instance that will host the QDB. To specify a SQL Server instance, use the format Server_Name\instance.
Name of the QDB. Do not include spaces at the beginning or end of the QDB name, and do not specify a name that is longer than 128 characters. If the name is too long, the installation will fail.
Account that can log in to the SQL Server to create the QDB.
Specify initial sizes and locations for the QDB data and log files and click Next.
The minimum required value for the data file size is 100 MB. The default value is 2048 MB.
The minimum required value for the log file size is 50 MB. The default value is 512 MB.
You can adjust the default values based on the amount of data you intend to collect and the number of computers you plan to monitor. For more information about sizing the QDB, see Sizing the QDB.
Because the autogrowth rate is set to 256 MB for each file, allow at least enough free space to accommodate the autogrowth rate.
If you specify a non-default location for the files, ensure the folders exist before you install the QDB.
Provide information about the account that will own the QDB and click Next.
If you specify a Windows user account, the QDB becomes the default database for the Windows user in Microsoft SQL Server. Before you uninstall the QDB, use Microsoft SQL Server Management Studio to change the default database for the Windows user account to an appropriate system database. Otherwise, the Windows user will not be able to connect to the SQL Server after you uninstall the QDB. For more information about uninstalling the QDB, see Section C.0, Uninstalling AppManager.
Select to configure security for Windows agents only, UNIX agents only, or both and click Next.
NetIQ Corporation recommends initially configuring all Windows agents and all UNIX agents to use the same security level. After installation, you can use the NQKeyGenWindows.exe and NQKeyGenUnix.exe utilities to manage security separately for Windows and UNIX agents. For more information about using these utilities, see the Administrator Guide for AppManager, available on the AppManager Documentation page.
Select the security level for communication between management servers and agents and click Next.
For more information about the security levels, see Understanding QDB Security Options.
(Conditional) If you selected Encrypted communications only or Authentication and encrypted communications, specify a password for retrieving encryption keys from the QDB and click Next.
For information about QDB encryption keys, see the Administrator Guide for AppManager, available on the AppManager Documentation page.
(Conditional) If you selected Encrypted communications only or Authentication and encrypted communications, provide the following information and click Next:
A password for the agent to access its portion of the QDB encryption key
The location for the agent encryption key file
For Windows agents, you can also select to export the key information to a text file. For UNIX agents using authentication and encrypted communications, the key file information is automatically exported to a text file. For UNIX agents using encrypted communications only, the key file information is not exported to a text file.
The name of the Windows agent key file is nqWindowsPublic0.key and the name of the UNIX agent key file is nqUNIXPublic0.key. You can rename and move the key files after installation. You will need the agent key file location when you install Windows agents. For more information about the key files, see the Administrator Guide for AppManager, available on the AppManager Documentation page.
Review the installation settings. When you are ready to install the QDB, click Install.
For the QDB to function correctly, you must also install the Task Scheduler service and add the QDB to the service. For more information about installing and configuring the service, see Understanding Task Scheduler Service Installation, Installing the Task Scheduler Service, and Adding Repositories to the Task Scheduler Service.
After you install Control Center components, you can use Control Center to manage QDBs. To manage a QDB through Control Center, use the Control Center console to add the QDB to Control Center. You cannot add a QDB to more than one CCDB. The primary QDB must be the same version as the CCDB. Before you add an existing non-primary QDB to Control Center, ensure that it is version 8.2 or later.
For more information about installing Control Center components, see Section 7.0, Installing Control Center Components. For more information about adding a QDB to Control Center, see the Control Center User Guide for AppManager, available on the AppManager Documentation page.