New Installation › Windows › BIEK--Perform a New Installation › CMS Database Configuration › 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 to hold the BusinessObjects Enterprise CMS database. Use this screen to enter connection and authentication details for the database.

To configure an existing database server

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

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

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

   The following information summarizes all the information required for each database type:

   Microsoft SQL Server (ODBC)

   • ODBC DSN (Specified in Control Panel's Data Sources (ODBC) applet)

   Oracle

   • Server: tnsnames connect identifier
   • Login credentials

   DB2

   • Server: DB2 database alias
   • Login credentials

   MySQL

   • Database: MySQL database name
   • Server: MYSQL server name
   • Port: Default port is 3306
   • Login credentials

   Sybase

   • Server: Sybase Server Name
   • Login credentials

   Note: The Sybase server name is a combination of the host name and the port number which is set by your database administrator in the file sql.ini.

3. To provide an ODBC DSN for a Microsoft SQL Server:
   1. Click the Browse button in the CMS Database area.
   2. Use the SQL Server Logon screen to select a data source, database, and to provide user credentials.
   3. If you are installing on a 64-bit version of Windows, you should select the Consume DSN created under WOW64 check box. This enables you to use 32-bit DSN. You also need to use odbcad32.exe (found under C:\Windows\SysWOW64) to create a system DSN.
   4. Click OK to submit your settings.

      The SQL Server Logon screen is closed and an ODBC DSN entry displays in the ODBC DSN field.

   5. Select the Auditing Database check box to set up an existing auditing database. If you do not want to specify an auditing database for your new installation, skip to step 6.

      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 the Auditing Database pane.

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

5. Provide all the required information for the database in the fields provided in the Auditing Database pane.
6. Select the Reset existing database check box to delete all current tables and entries in existing database CMS and auditing databases.
7. Click Next to continue with the installation.

   The Select Web Application Server screen displays. This screen only displays if a connection is established with the database configuration you provided.