Installation on Widlfy 8.2.1 is failing on database credentials

Products

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

Issue/Introduction

Issue: 

Identity Portal installation program reaches the database credentials step and fails to go beyond even when all details are correct.

Cause: 

This happens when the installer cannot create the JDBC data source 

Environment

Release: CAIDMB99000-12.6-Identity Manager-B to B
Component:

Resolution

The data source has to be made manually.

Here are the steps to create the data source:

Name: sigma-ds

JNDI Name: java:jboss/datasources/jdbc/sigmadb

Connection URL: jdbc:sqlserver://<servername>:<port>;databaseName=<db_name>

Username: <your username>

Password: xxxxxxxx

 

Then Test Connection.

Edit sigma-ds connection tab, and disable "use CCM"

Go to Pool tab, and set Max Pool Size to 25

Enable data source and continue Identity Portal Installation