When attempting to test the connection to the MS SQL adapter in TDV (TIBCO Data Virtualization) Studio using the "integratedSecurity=true" parameter in the JDBC URL, an error occurs if the appropriate JAR files are not utilized:
The sample error message below pertains to the MS SQL 2019 adapter:
====
Unable to connect to the data source "/shared/MS SQL 2019" at "na2devspwsql02.dev.tibco.com:1433@AdventureWorks" with the supplied connection information.  [datasrc-3961050]
This driver is not configured for integrated authentication. ClientConnectionId:76c16a8c-6eb9-4b82-b8de-a2969f98fe25 [Log ID: 70504e39-93e3-49d6-b5ba-b99ba3b8ec00]
====

The purpose of this article is to elucidate how to configure MS SQL Server in the TIBCO Data Virtualization server to use Windows Authentication.

Windows Environment

To resolve this error, follow the below steps in order:

(1) Locate the JAR file for your version of SQL Server. Kindly navigate to the Microsoft JDBC Driver for SQL Server Web page at the provided URL and download the appropriate JDBC driver for your specific version of SQL Server.
https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

(2) Put the JAR file in the directory appropriate to the version: \conf\adapters\system\microsoft_sql_server_<ver>
      -  Example to configure the MS SQL 2019 adapter in TDV (TIBCO Data Virtualization) Studio : Add the  mssql-jdbc-8.4.1.jre11.jar to - <TDV_install_dir>/conf/adapters/system/microsoft_sql_server_2019/ 
      -  Please be aware that the JAR files will vary depending on the version of MS SQL in use.
        -  For Example : Add the mssql-jdbc_auth-8.4.1.x64.dll to - <TDV_install_dir>/apps/server/lib/win64/ in order to establish a connection to the MS SQL 2019 data source
      -  For Example : Add the Common_WindowsSSPI_JNI.dll, sqljdbc_auth.dll (version 7.4.1.0) OR sqljdbc_auth.dll (version 6.4.1.0) to -  <TDV_install_dir>/apps/common/lib/win64/
      -   Note: If you do not have a 'win64' folder under <TDV_install_dir>/apps/server/lib/win64/ please create one. 

(4) Copy the  mssql-jdbc-8.4.1.jre11.jar to <TDV_install_dir>/apps/dlm/cis_ds_mssql/lib
      Note: Please do not delete them from their existing location, just make a copy to the specified path.

(5) Please verify that the "log on" user for the TDV Monitor service is an authorized Windows user with sufficient rights to access the SQL Server and not the Local System user.
      - It is crucial to ensure this as TDV relies on Windows integrated authentication to access the SQL Server data source.
      - When entering the credentials for the TDV Server service, make sure to use the format "domain\username" to accurately specify the user name.

(6) Restart the TDV(TIBCO Data Virtualization) Server

(7) Test connection to the MS SQL Server data source in TDV Studio.

Note: If integrated security is required, it is recommended to keep the SQL server JDBC drivers in a common location. For example, \apps\dlm\cis_ds_mssql\lib."
 

Adapter Guide (Refer Point 6 under Obtain and Install the Driver for SQL Server): https://docs.tibco.com/pub/tdv/8.5.5/doc/pdf/TIB_tdv_8.5.0_AdapterGuide_MSSqlServer.pdf#page=20
Administration Guide (Refer section: Configuring SQL Server in the TDV Server to use Windows Authentication) : https://docs.tibco.com/pub/tdv/8.5.4/doc/pdf/TIB_tdv_8.5.0_AdministrationGuide.pdf#page=436