MS SQL jdbc connection error while enabling

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.

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

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