IBM QRadar

Hi,

I have an issue with my JDBC connexion. I am experiencing an issue with the connection to my SQL database using the JDBC driver. I noticed that the JTDS driver is not included in the connection string.

this is the error 

Attempting connection with JDBC connection url [jdbc:sqlserver://1.1.1.5\OPER_1:1433;databaseName=AA;encrypt=false;statementPoolingCacheSize=10;queryTimeout=300] with a connection timeout of [10] seconds.Error: Unable to communicate with a database for the following reason : The TCP/IP connection to the host 10.31.150.25, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".. The connection url was : jdbc:sqlserver://1.1.1.5\OPER_1:1433;databaseName=AA;encrypt=false;statementPoolingCacheSize=10;queryTimeout=300Debug: SQLServerException: The TCP/IP connection to the host 1.1.1.5, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

the other JDBC connections have the this string : [jdbc:jtds:sqlserver://

I reviewed the following link for assistance:
IBM Support

Hi Benjamin,

Is this a new logsource?

I would ensure that your DSM RPMS and Protocol RPMS are all uptoday as per the versions available on https://www.ibm.com/support/fixcentral

Specifically looking at the JDBC protocol.  If this is uptodate then try and re-install it. 

If this does not work I would suggest to open a support case.

Thanks

Hi,

I have an issue with my JDBC connexion. I am experiencing an issue with the connection to my SQL database using the JDBC driver. I noticed that the JTDS driver is not included in the connection string.

this is the error 

Attempting connection with JDBC connection url [jdbc:sqlserver://1.1.1.5\OPER_1:1433;databaseName=AA;encrypt=false;statementPoolingCacheSize=10;queryTimeout=300] with a connection timeout of [10] seconds.Error: Unable to communicate with a database for the following reason : The TCP/IP connection to the host 10.31.150.25, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".. The connection url was : jdbc:sqlserver://1.1.1.5\OPER_1:1433;databaseName=AA;encrypt=false;statementPoolingCacheSize=10;queryTimeout=300Debug: SQLServerException: The TCP/IP connection to the host 1.1.1.5, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

the other JDBC connections have the this string : [jdbc:jtds:sqlserver://

I reviewed the following link for assistance:
IBM Support