Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

3
Replies
433
Views
ABBURIM1 Member since 2004 5 posts
TCS
Posted: Feb 14, 2017
Last activity: Feb 15, 2017
Closed

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.

Show More

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


Show Less
To see attachments, please log in.
Installation and Deployment

Posted: 8 years ago

Can you confirm if you leave the connection details the same, but change just the driver in use to the JTDS version, the test connection works?

Can you provide a screen shot of the error you see when using the SQL JDBC Driver from Microsoft?

Have you tried the latest version of that Microsoft driver? If so, can you provide the link to which one you tried?

Can you provide us with the JDBC URL you're using? (You can adjust the server name)

To see attachments, please log in.
Posted: 8 years ago

Hi Nick,

Thanks for the quick response. I may not able to provide the screenshot of the error, because of some restrictions. And I will try to get the info.

Just want to check whether the Window authenticate user can do Pega installing on Linux server? . 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice