The first time that you log in to CCS is unique. Instead of logging in and being presented with the standard CCS Administration desktop, you are instead presented with the database connection wizard. You must configure the database connection before you can continue configuring CCS.
To login and configure the database:
To log in to Collaboration as the Super Administrator:
Open a Web browser and enter the URL http://<CCS server>/admin.
In the Login Name field, enter admin.
In the Password field, enter Password. The password is case sensitive.
Click the Log in button. The Database Connection Wizard appears. The normal Administration desktop appears after you have configured the database connection.
Note: Collaboration Server compiles each page the first time it is used. As a result, Administration runs slowly on a newly installed system. Performance returns to normal on the second and subsequent uses.
To complete the Database Connection Wizard:
Select the database type: Oracle 8i, or Microsoft SQL Server 2000.
Select the JDBC driver that you are using. If you are using Oracle 8i, then you should have already installed the Oracle JDBC drivers. If you have not installed the Oracle JDBC driver then you must stop IIS, install the drivers, and restart IIS. The Microsoft SQL Server 2000 drivers are installed automatically by CCS.
Oracle 8i |
Microsoft SQL Server 2000 |
Oracle Thin JDBC Driver V8.1.7 |
Inet Microsoft SQL Server Driver Sprinta2000 v4.18 |
Fill in the Database Connection properties:
Property |
Description |
|
Oracle 8i |
MS SQL 2000 | |
Host |
The hostname for the server on which the database server software is running. For example database.mycompany.com. |
|
Port |
Port 1521 by default |
Port 1433 by default |
System ID (SID) |
The System ID (database name) of the database that you use for CCS. |
N/A to MS SQL |
Database Name |
N/A to Oracle |
The database name of the database that you use for CCS |
Database Login Name |
The Username of the user with access rights to the database. |
|
Password |
Your database password. |
|
Verify Password |
Your database password again for verifivaiton. |
|
Description |
A brief description of this connection. This field is optional. |
Click Next
to verify the Database Connection Wizard. A confirmation screen
is displayed verifying your settings. If there were no errors then "The
current database connection settings have been verified." is displayed.
If there are errors, then they are displayed on the screen along with
possible solutions. Follow the directions on the screen to fix the problem.
If there are no problems click Apply.
Note: It may take a few minutes for the next screen to
appear. Do no click Apply again.
If this is the first time that you have connected to the database from CCS, then the Database Connection Wizard attempts to create the CCS schema in the database. Click Finish to allow the Database Connection Wizard to create the CCS schema in the database. The Database Utilities applet creates the schema:
If you have not installed the Database Utilities Applet before you must click Yes in the Security Warning dialog box to allow the Database Utilities Applet to be installed on your system.
The Database Utilities
Applet attempts to create the database scheme. Any errors that are encountered
are shown on the screen. If you encounter any errors you must fix them
according to the instructions on the screen and then RESTART IIS so that
the Database Utilities Applet can re-run.
Note: After setting up the database connection, you can use Collaboration without shutting down and restarting the server. If you make changes to the database connection after installation, however, you must restart the server before the changes will take effect.
To verify the CCS install:
Select Collaboration Server > Agents > Show.
CCS is correctly installed and functioning if:
A list of agents is displayed (if the database was previously populated with agents), or
The screen says "There are no agents currently defined. Click Agents:Create to create an agent."
CCS is NOT correctly installed if:
An error occurs (denoted by a large exclamation point within a red triangle). The most common error is using the incorrect JDBC driver, OR incorrect database settings. Re-run the Database Connection Wizard from Collaboration Server > Server Setp > Database > Setup Wizard.