Cisco Cisco Administrative Workstation Release Note

22.  In the Enterprise Manager Login dialog box, select Connect Directly to a Database. 

o 

Enter “internal” for the Username. 

o 

Enter “Cisco” for the Password. 

o 

Enter the <name of database> for the Service. Example “ccsdb”. 

o 

For the Connect As screen, select SYSDBA from the menu. Click OK. 

23.  In the SQL Plus Worksheet Application, delete the highlighted text. Copy the text below into this 

window. The text is one line, and that a semicolon indicates a new line. 

 

The following names are used on the Collaboration Server: 

o 

Tablespace name – ccstable 

o 

Datafile name – ccsdata 

o 

Username – ccsuser 

o 

Password – Cisco 

CREATE TABLESPACE <Collaboration DB tablespacename> DATAFILE '<Collaboration DB 
datafilename>' SIZE 30M;  

CREATE USER <Collaboration DB username> IDENTIFIED BY <Collaboration DB password> 
DEFAULT TABLESPACE <Collaboration DB tablespacename>;  

COMMIT; 

Click on the Execute icon 

GRANT CONNECT, RESOURCE TO <Collaboration DB username>;  

COMMIT; 

Click on the Execute icon 

Click on File > Exit to finish 

 

o 

Install SQL2000 using the typical install. 

o 

Use the Enterprise Manager to create a database. 

o 

Use the Enterprise Manager to create a user. 

o 

Assign that user to the database created for CCS and assign these rights:  

o 

db_owner  

o 

db_accessadmin  

o 

db_securityadmin  

o 

db_ddladmin  

o 

db_backupoperator  

o 

db_datareader 

o 

db_datawriter 

You can now load the ICM Software Modules on the individual Servers (see 

When ICM Setup loads the ICM Logger and Admin Workstation software, it creates specific domain level 
groups and accounts in the ICM domain it is loaded into.   

To run the ICM Setup for the Loggers, Administrative Workstations and CallRouters, you must be logged 
in with a Domain Admin level account.  You can perform a Peripheral Gateway setup with a user account 
that has “admin” rights on the server itself.