CMS Database Configuration

To configure your SQL Anywhere database server

The "SQL Anywhere Database Server Configuration" screen appears if you chose to install SQL Anywhere as part of the BusinessObjects Enterprise installation.

1. Specify the Data Source Name for the SQL Anywhere Server. Defaults is BOE120.

2. Specify the port number for the SQL Anywhere database server in the SQL Anywhere Port Number field.
The default port number is 2638. Use this number unless the port is unavailable.

3. Specify and confirm a password for the SQL Anywhere DBA user account in the SQL Anywhere DBA User Account area.

4. Confirm the username and give a password for the SQL Anywhere BusinessObjects database user account in the SQL Anywhere BusinessObjects User Account area and click Next. Note that the username must be unique on the network.
The "Select Web Application Server" screen is displayed.

To configure an existing database server

The "CMS Database Information" screen appears if you chose to use an existing database server to hold the BusinessObjects Enterprise Central Management Server (CMS) database. Use this screen to enter connection and authentication details for the database.

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 table below summarizes all the information required for each database type:

Database Type	Information required at install time
SQL Anywhere	· ODBC DSN · Database Name · Server Name · Port · Login Credentials
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 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.

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 have the option to select the Consume DSN created under WOW64 checkbox.

4. Click OK to submit your settings.
The "SQL Server Logon" screen is closed and an ODBC DSN entry is displayed 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.

If you do not install an auditing database, you can use the "Add/Remove Programs" applet in the Windows Control Panel to add an auditing database later. Adding an auditing database from the "Add/Remove Programs" applet requires you to configure the auditing database using the Central Configuration Manager (CCM). For information on configuring an auditing database with the CCM, see “Configuring auditing for servers on Windows” in the SAP BusinessObjects Enterprise Administrator's Guide. The input fields under the Auditing Database box are activated.

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

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

8. Select the Reset existing database box to delete all current tables and entries in existing database CMS and auditing databases.

9. Click Next to continue with the installation.
The "Select Web Application Server" screen is displayed. This screen only displays if a connection is established with the database configuration you provided.