Installation Guide › Installing an AIX Implementation › Install and Configure Workpoint Components on AIX/WebSphere › Create SQL Databases for the Workpoint Cluster

Create SQL Databases for the Workpoint Cluster

The CA RCM Workpoint cluster uses several databases.

To create databases for the Workpoint cluster

1. Create the following databases.
   • Workpoint database named WPDS (this is typically created by the CA RCM installer).
   • Workpoint bus queue database named wpBusQueueDB

   These databases must be accessible with the same username and password you specified for other CA RCM databases.

2. (Microsoft SQL Server only) Set the Collation (Options, Collation) for these databases to Latin1_General_CS_AI.
3. (Microsoft SQL Server only) Create a user for each database. Assign the users the db_owner role when you create the database. After installation, you can change the role assignment to db_datareader and db_datawriter.
4. (Microsoft SQL Server only) Assign the SqlJDBCXAUser role to the user you create for the WPDS database.