Custom or Expand Installations › Windows › Perform a Custom or Expand Installation › Install Only the Server Components › Configure an Existing Database Server

Configure an Existing Database Server

The CMS Database Information screen displays if you chose to use an existing database server as your CMS for your Custom or Expand installation.

To configure an existing database server

1. Select a database type from the Select existing CMS database drop-down list in CMS Database.

   Depending on your database server selection, corresponding input fields are displayed in CMS Database.

2. Provide all the required information for the database in the fields provided in CMS Database.

   The following list summarizes the information that is required for each database type:

   SQL Anywhere

   Data Source Name

   MySQL

   Data Source Name

   Sybase

   Sybase Server Name

   DB2

   DB2 database alias

   Oracle

   tnsnames connect identifier

   Microsoft SQL Server

   ODBC DSN

   1. To provide an ODBC DSN for a Microsoft SQL Server, click the Browse button in CMS Database.

      The SQL Server Logon screen displays.

      Note: If you are running the installation on a Windows 64-bit computer an additional check box - Consume DSN created under WOW64 - displays, which must be selected to use 32-bit DSN.

   2. Use the SQL Server Logon screen to select a data source, database, and to provide user credentials.
   3. Click OK to submit your settings.

      The SQL Server Logon screen is closed and an ODBC DSN entry displays in CMS Database.

      If you do not want to specify an auditing database for your new installation skip to step 6.

3. Select the Auditing Database check box to specify an auditing database for your new installation.

   The input fields under the Auditing Database check box are activated.

4. Select a database type from the Select existing Auditing database drop-down list in Auditing Database.

   Depending on your database server selection, corresponding input fields are displayed in Auditing Database.

5. Provide all the required information for the database in the fields provided in Auditing Database.

   The following list summarizes the information that is required for each database type:

   SQL Anywhere

   Data Source Name

   MySQL

   Data Source Name

   Sybase

   Sybase Server Name

   DB2

   DB2 database alias

   Oracle

   tnsnames connect identifier

   Microsoft SQL Server

   ODBC DSN

6. Select the Reset existing database check box to delete all current tables and entries in the existing database.
7. Click Next to continue with the installation.

   The Start Installation screen displays. This screen only displays if a connection is established with the database configuration you provided.