vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

Add support to TDS-8.0 for vertx-mssql-client

Open bkoripalli opened this issue 1 year ago • 0 comments

Describe the feature

vertx-mssql client (4.4.3) is failing to conect mssql server 2022 over ssl when Force Strict Encryption is enabled.

Getting the below error in Application:

Could not connect io.vertx.sqlclient.ClosedConnectionException: Failed to read any response from the server, the underlying connection may have been lost unexpectedly. io.vertx.sqlclient.ClosedConnectionException: Failed to read any response from the server, the underlying connection may have been lost unexpectedly.

Below Error in DB side: The SQL Server or the endpoint is configured to accept only strict (TDS 8.0 and above) connections. The connection has been closed.

Ref: https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8?view=sql-server-ver16#how-tds-works

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/protocols-for-mssqlserver-properties-flags-tab?view=sql-server-ver16#force-strict-encryption

Use cases

Connect DB with SSL & Enable Force Strict Encryption Yes in mssql server 2022

Contribution

Who should implement this feature ? are you volunteering for implementing this feature or do you know that is able and willing implement this feature ?

bkoripalli avatar Nov 26 '24 04:11 bkoripalli