MS SQL jdbc connection error while enabling

, ,
1

Connection details:
Transaction Type LOCAL_TRANSACTION
DataSource Class com.microsoft.sqlserver.jdbc.SQLServerDataSource
Server Name localhost
User nicdb
Password ******
Database Name nicdb
Port Number 2383
Network Protocol
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
Heart Beat Interval (sec) 0

Error:
Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource temp:temp1.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection temp:temp1: after 1 attempt(s).
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
Connection reset ClientConnectionId:cb60f3c3-8647-4613-9d3c-e7b3f39f9da3

Jars placed:
mssql-jdbc-8.4.1.jre8.jar

Java Version 1.8.0_222 (52.0)

IS Version 10.5.0.0

Please help.

2

Hi Rajesh,

are you sure about the port?
Default Port for MS SQL is 1433 afaik.
Additionally check for the content of “Other Properties” as “driverType=thin” is typically used with Oracle Databases but not with MS SQL Databases.

Is there anything in the logs and/or protocols of the MS SQL Database, why the connection was reset by the database?

Which JDBC Adapter version are you running on?
As this is IS 10.5 I would assume JDBC Adapter 10.3.

Regards,
Holger

1 Like
3

Dear Holger,

Thankyou so much for the directions.It worked.

Steps i followed:

Removed the Other Properties from connection.
Repointed to port 1433
Using SQL configuration mgr enabled the tcp/ip port for 1433.

Thankyou :slight_smile:

1 Like