7.4 Installing the CCDB

This section describes the steps required to install the CCDB on local and remote SQL Servers.

To install the CCDB:

  1. Ensure the accounts required to install the CCDB are properly configured.

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

  2. Complete the steps in Understanding the AppManager Pre‑Installation Check.

    After you view the pre-installation check report, click Next to start the installation.

  3. 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 CCDB. To specify a SQL Server instance, use the format Server_Name\instance.

    • Name of the CCDB. Do not include spaces at the beginning or end of the CCDB 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 CCDB.

  4. Provide information about the account the command queue service will use and click Next.

  5. Provide information about the account that will own the CCDB and click Next.

    If you specify a Windows user account, the CCDB becomes the default database for the Windows user in Microsoft SQL Server. Before you uninstall the CCDB, 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 CCDB. For more information about uninstalling the CCDB, see Section C.0, Uninstalling AppManager.

  6. Specify initial sizes and locations for the CCDB’s data and log files and click Next.

    The minimum required value for the data file size is 512 MB. The default value is 1024 MB.

    The minimum required value for the log file size is 50 MB. The default value is 512 MB.

    Adjust the data and log file sizes based on the number of CCDBs you plan to manage and the number of management groups and views you plan to create.

    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 CCDB.

  7. Provide information about the account the Deployment Service will use and click Next.

    You can specify the same account you specified for the command queue service, or you can specify a different account.

  8. Review the installation settings. When you are ready to install the CCDB, click Install.

For the CCDB to function correctly, you must also install the Task Scheduler service and add the CCDB 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.