Add support to TDS-8.0 for vertx-mssql-client
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 ?