This driver is not configured for integrated authentication.

[Damir_Bag]

Hello!

We have a problem with authentication on the Kaspersky database.There are errors in the logs:

[ERROR][default.com.arcsight.agent.loadable.agent._KasperskyXXX][setDeviceConnectionState] Device connection to [jdbc:sqlserver:/xxx\SQLEXPRESS;DatabaseName=xxx;integratedSecurity=true|xxx] down.(Unable to detect database version.
Tried version [10.0]. ERROR: [This driver is not configured for integrated authentication. ClientConnectionId:6d8c26d1-cbc6-4705-ab64-79014601d8fe]
)

We re-created the connector again with the backup of the previous connector (created a new service on Windows). The connector in ESM works, the service in Windows works. Moved files mssql-jdbc-8.4.1.jre8.jar and sqljdbc4.jar from the previous connector in the current\user\agent\lib directory and moved the file sqljdbc_auth.dll in the current\jre\bin directory. I tried to change the bit depth of the driver, threw the bit depth of x86 and x64, but the error returns.

Tell me, please, has anyone seen such an error and how it can be solved?

[richhamilton · Accepted solution]

You didn't mention which version of the connector you are using. Depending on the connector version then you may need to provide different jar files:

• Version 7.2.1 and later use JRE 1.8 and require sqljdbc42.jar (available with Microsoft JDBC Driver 6.0 for SQL Server)
• Version 7.1.2 and later use JRE 1.7 and require sqljdbc41.jar (available with Microsoft JDBC Driver 6.0 for SQL Server)
• Prior versions, which run JRE 1.6, require sqljdbc4.jar (available with Microsoft JDBC Driver 4.0 for SQL Server)

Source: SmartConnector for Kaspersky DB - Micro Focus Community - 1588684 page 4