unable to use connector server management of CAIG to connect mssql database

Document ID : KB000072532
Last Modified Date : 19/04/2018
Show Technical Document Details
Issue:
When tried to connect mssql database from CAIG's from connector server management. When invoked the import on a universe that contains this jcsconnector following error message is resulting. Error 16-Jan-2018 11:11:42 Run Connector Error occurred while running import connector JCS VERIFICATION-Connector Server. Error 16-Jan-2018 11:11:42 Run Connector Error: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.clientconnection.clientapi.ClientConnectionException: java.util.concurrent.ExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.iam.model.IAMPersisten... 11:11:42,226 INFO [com.eurekify.connectors.ccl.session.JCSSession] (import-connector thread-2) Final import time: |--- Import from jcs mssqld31@MS SQL Server: sum of children: 1 seconds , self: 719 ms |--- RCM: sum of children: 15 ms , self: 1 seconds |--- SQLServerRole: sum of children: 0 ms , self: 15 ms |--- SQLRole: sum of children: 0 ms , self: 0 ms |--- JCS: sum of children: 438 ms , self: 0 ms |--- SQLServerRole: sum of children: 0 ms , self: 172 ms (8 Objects and 0 Associations) |--- SQLRole: sum of children: 0 ms , self: 266 ms (0 Objects and 0 Associations) 11:11:42,242 WARN [com.ca.rcm.services.trace.TraceMessage] (import-connector thread-2) TraceMessage param1 value is too long: 706 it will be truncated to 256 characters; value: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.clientconnection.clientapi.ClientConnectionException: java.util.concurrent.ExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.iam.model.IAMPersisten... 11:11:42,758 ERROR [com.eurekify.batch.connectors.imports.AbstractEmbeddedClientConnectionLayerImport] (import-connector thread-2) Import Failed!: com.eurekify.command.CommandExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.clientconnection.clientapi.ClientConnectionException: java.util.concurrent.ExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.iam.model.IAMPersistenceException: javax.naming.NamingException: [LDAP: error code 80 - code 80 (OTHER-LdapNamingException): failed on search operation: eTSQLDirectoryName=mssqld31,eTNamespaceName=MS SQL Server,dc=im,dc=etasa: JCS@aws-idgovdev1: SQL: Bad SQL Grammar: The server principal "rcm_admin_user" is not able to access the database "dbm" under the current security context.]; remaining name 'eTSQLDirectoryName=mssqld31,eTNamespaceName=MS SQL Server,dc=im,dc=etasa' at com.eurekify.command.AbstractCommand.execute(AbstractCommand.java:54) [eurekify-common-14.0.0-SNAPSHOT.jar:]
Resolution:
This is in the IM docs. https://docops.ca.com/ca-identity-manager/14-2/EN/installing/installation-prerequisites/complete-the-installation-worksheets Username The username for database access. Note: This user must have administrative rights to the database unless you plan to import the schema manually.