Cannot connect to MSSQL via JDBC from ca api layer7 gateway

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

Initital setup of driver was below, 

Drvier: com.l7tech.jdbc.sqlserver.SQLServerDriver

JDBC URL : jdbc:sqlserver://<SQL Server Name>:1433;databaseName=<DBname>

Then User and PASSWORD

Error: Testing failed: invalid connection properties setting. No suitable driver

 

Environment

Release : 9.4

Component : API GATEWAY

Resolution

Driver: com.l7tech.jdbc.sqlserver.SQLServerDriver

JDBC URL : jdbc:l7tech:sqlserver://<SQL Server Name>:1433;databaseName=<DB Name>

So instead of
jdbc:sqlserver://
use
jdbc:l7tech:sqlserver://

Set the following properties on the node,
vi /opt/SecureSpan/Gateway/node/default/etc/conf/system.properties
** And add the following 2 properties.


com.l7tech.server.jdbcDriver=com.mysql.jdbc.Driver\ncom.l7tech.jdbc.mysql.MySQL
Driver\ncom.l7tech.jdbc.db2.DB2Driver\ncom.l7tech.jdbc.oracle.OracleDriver\ncom
.l7tech.jdbc.sqlserver.SQLServerDriver

com.l7tech.common.security.jceProviderEngineName=bc

*** The above system.properties must exist on all nodes of the cluster and once adding you must restart the ssg service.

And then use a SQL user like sa, not a windows user.
And testing is success.