3462480 - "Adapter validation failed" error when validating MS SQL connection

Error is raised during validation of Microsoft SQL Server connection created in SAP Datasphere

Connection "Connection_name" couldn’t be established. - Data flows can’t be used because of errors in the connection. - Replication flows are not supported. - Remote tables can’t be used because of errors in the connection.
Data Flows: Cause: Timed out while connecting to the source
Remote Tables: Unable to connect remote source: Adapter validation failed. [XXX_XXX.XXX]Failed to establish JDBC connection. Error: This driver is not configured for integrated authentication. ClientConnectionId:XXXXXXXXXXXXXXXXX, Code: 5921, SQL State: HY000

Correlation ID: xxxxxx-xxxxx-xxxx

SAP Datasphere

mssql, jdbc, connection, Datasphere, driver, mssqllogreadadapter  , KBA , DS-DI-CON , Connections , Problem