Not able to connect to DB
We are facing some DB connectivity issues while installing Pega 7,2,2 on Linux using tomcat and sql server. And we are trying to load the rules into DB using the PRPC_Setup.jar and provided the necessary DB details like DB name, Drivers, JDBC URL, user name and password on click of test connectivity we are getting an error “Failed to connect to the DB”.
Following are the drivers we have tried to connect to DB
JTDS -
-
Able to connect to DB, and DB Tables, UDFs etc. got installed.
-
Pega installation failed and it stated an error that driver version 3..X.X is incompatible with JDBC 4.0 and hence installation cannot proceed.
SQL JDBC Driver from Microsoft
-
Unable to connect to DB with Logon Failed exception.
We are facing some DB connectivity issues while installing Pega 7,2,2 on Linux using tomcat and sql server. And we are trying to load the rules into DB using the PRPC_Setup.jar and provided the necessary DB details like DB name, Drivers, JDBC URL, user name and password on click of test connectivity we are getting an error “Failed to connect to the DB”.
Following are the drivers we have tried to connect to DB
JTDS -
-
Able to connect to DB, and DB Tables, UDFs etc. got installed.
-
Pega installation failed and it stated an error that driver version 3..X.X is incompatible with JDBC 4.0 and hence installation cannot proceed.
SQL JDBC Driver from Microsoft
-
Unable to connect to DB with Logon Failed exception.
-
Tried using the following parameter "integratedSecurity=true" in the connection URL as mentioned in the installation document – but no luck