Unable to connect to GTSubset using Windows authentication.

[Sethu]

Hi Team,

We are trying to connect GTSubset using the Windows Integrated authentication. Looks like there is issue with the sqljdbc_auth.dll.

The details of the error message is as below:
This driver is not configured for integrated authentication. ClientConnectionId:b0b1ad3a-b4a4-4ce3-8849-6fd764c00e6d
Incorrect version of sqljdbc_auth.dll in current directory.
please copy correct version for your operating system from SQLSERVER_DLLs sub directory.

Below are the list of troubleshooting that was done so far:
1. We tried to find out from which location the dll is being called using procmon and placed the dll in the appropriate path, but the issue still exists.
2. The details for the dll call has got "FILE LOCKED WITH ONLY READERS" message from procmon.
3. We verified the access to the folder and the file and everything is intact. 
4. The date timestamp for the x86 version of the dll that we are using is 8/31/2020 and the size of the dll is 250kb.
5. Got a patch for subset and replaced all the lib items, as well.

Please let me know if you need any additional details on this.

Thanks!

[Bradley Gray]

Hi Sethu,

According to the error message, the application doesn't like the version of sqljdbc_auth.dll. It's telling you that the version is incorrect. It could be you have a 64-bit dll where we are expecting a 32-bit version, or vice versa.

Could you do a search for sqljdbc_auth.dll and provide a listing of everywhere the drive is found? I ran a search on my 4.9.1 working Datamaker server, and received 20 locations where the driver is found:

• C:\Program Files\CA\CA Test Data Manager Portal\schema-management\lib\
• C:\Program Files\CA\CA Test Data Manager Portal\service\lib
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\auth\x64\
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\auth\x86\
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 6.4 for SQL Server\sqljdbc_6.4\enu\auth\x64\
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 6.4 for SQL Server\sqljdbc_6.4\enu\auth\x86\
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 7.0 for SQL Server\sqljdbc_7.0\enu\auth\x64\
• C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\Microsoft JDBC Driver 7.0 for SQL Server\sqljdbc_7.0\enu\auth\x86\
• C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x64\
• C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x86\
• C:\Program Files (x86)\Grid-Tools|GTDatamaker\GTFiles\SQLSERVER_DLLs\
• C:\Program Files (x86)\Grid-Tools|GTDatamaker\GTFiles\SQLSERVER_DLLs\x64\
• C:\Program Files (x86)\Grid-Tools|GTDatamaker\SQLSERVER_DLLs\
• C:\Program Files (x86)\Grid-Tools|GTDatamaker\SQLSERVER_DLLs\x64\
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_6.2.2.1\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\auth\x64
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_6.2.2.1\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\auth\x86
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_6.4.0.0\Microsoft JDBC Driver 6.4 for SQL Server\sqljdbc_6.4\enu\auth\x64
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_6.4.0.0\Microsoft JDBC Driver 6.4 for SQL Server\sqljdbc_6.4\enu\auth\x86
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_7.0.0.0\Microsoft JDBC Driver 7.0 for SQL Server\sqljdbc_7.0\enu\auth\x64
• C:\Users\<Username>\Downloads\JDBC_Drivers\SQL\SQL_7.0.0.0\Microsoft JDBC Driver 7.0 for SQL Server\sqljdbc_7.0\enu\auth\x86

Regards,

Brad