Could not create connection Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'idm.portal'

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

Identity portal is down. Service will not deploy after creating new database user and updating the credentials in vApp for external datasource.

Environment

Release : 14.1

Component : IdentityMinder(Identity Manager)

Resolution

[0m22:08:02,345 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (MSC service thread 1-6) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'idm.portal'. ClientConnectionId:5a2c1696-19bf-458a-afbb-4128c653ad88

Pleaser check the credentials for the idm.portal user for the external DB - might have expired or password changed
if so portal cannot connect to DB and therefore cannot start

after user was created deployment still stopped but because of the password

Customer had a # infrom of the new password and it failed to encrypt the password.

******************************************
config@######### (##.##.###.##):/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/PasswordTool > ./pwdtools.sh -JSAFE -p #password
--------------------------------------------------
Your JAVA_HOME is currently set to /opt/CA/jdk1.8.0_71/
--------------------------------------------------
Encrypting your password ...
******************************************

Usage:
- To create a FIPS key file
pwdtools -FIPSKEY -k [-f ]
- To add a FIPS key
pwdtools -FIPSKEY -add [-f ]
- To encrypt a plain text value using non FIPS (PBES) algorithm
pwdTools -JSAFE -p [-f ]
- To encrypt a shared secret using PBES algorithm and save it
pwdTools -JSAFEKEY -p [-f ]
- To encrypt a plain text using FIPS key file
pwdTools -FIPS -p -k [-f ]
- To encrypt a plain text value using non FIPS (RC2) algorithm
pwdTools -RC2 -p [-f ]
- To encrypt a plain text value using embedded CA NIM SM algorithm
pwdTools -CANIMSM -p

******************************************
config@######### VAPP-14.3.0 (##.##.###.##):/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/PasswordTool > ./pwdtools.sh -JSAFE -p password
--------------------------------------------------
Your JAVA_HOME is currently set to /opt/CA/jdk1.8.0_71/
--------------------------------------------------
Encrypting your password ...
******************************************
Plain Text: password
Encrypted value: {PBES}:##########
******************************************
config@######### (##.##.###.##):/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/PasswordTool > ./pwdtools.sh -JSAFE -p pass#word
--------------------------------------------------
Your JAVA_HOME is currently set to /opt/CA/jdk1.8.0_71/
--------------------------------------------------
Encrypting your password ...
******************************************
Plain Text: pass#word
Encrypted value: {PBES}:###########
******************************************