Create a database user account that Case Analyzer uses to connect to SQL Server databases that contain
the Case Analyzer store and
the Case Analyzer OLAP database.
- Create the following database account:
- Case Analyzer database user
(SQL Server)
-
- Unique identifier
- ca_db_administrator
- Description
- The database accounts that Case Analyzer uses
to access the SQL Server databases
that contain the Case Analyzer store
and the Case Analyzer OLAP database.
- ca_db_administrator must be a SQL Server account.
It does not have to be an account in the configured directory service.
- Minimum required permissions
-
In addition to the
Content Platform Engine database
user permissions, grant each
ca_db_administrator the
following permissions:
- db_securityadmin
- Bulk admin
Add these accounts to the master database for
SQL Server and grant the public role
to each. When you complete the procedure to grant the permissions
to participate in distributed transactions with the JDBC driver, these
accounts are also granted the SqlJDBCXAUser role.
For
more information, see Enabling
XA transactions.
- Create the following database account:
- Case Analyzer client database
user
-
- Unique identifier
- ca_client_database_user
- Description
-
The Windows (local or domain) user that you use to log on
to the Case Analyzer Client
server. This user must have permission to access the OLAP cubes on
the Case Analyzer analysis server.
This permission allows the client to connect to the Case Analyzer OLAP database.
- Configuration instructions
- For additional information about how to create this type of user
account, see Granting
access rights to the Case Analyzer OLAP database. Either of
the following configuration scenarios might apply, depending upon
the configuration of the environment:
- If the analysis server and Case Analyzer Client
server belong to the same LDAP domain: Give the domain user or group
access to the OLAP cubes on the analysis server.
- If the analysis server and Case Analyzer Client
server do not belong to the same domain: Create a duplicate of the
client user on the analysis server, and give the user access to the
OLAP cubes. When you create the duplicate user, the user must have
the same user name and password that is used for the Windows logon
to the Case Analyzer Client
server.
- Record these values in your customized Installation and Upgrade Worksheet. To find this property,
search the worksheet for instances of ca_db_administrator and ca_client_database_user.