DB Connect v3 MS-SQL Server: driver is not configured for integrated authentication

[performancemoni]

Hello,

We are running DB Connect v3.1.4 on a Linux machine and for the first time we are trying to connect to an SQL Server database via Windows authentication. We were always using local database accounts before, now the database admin configured one of our service account registered in the Active Directory to access the database.

Our user is "domain\username", we tried using the driver "MS-SQL Server Using MS Generic Driver With Windows Authentication", but when testing the new connection we get the error "

This driver is not configured for integrated authentication. ClientConnectionId: etc...

We checked the box in the identity creation to specify the domain and Splunk DB Connect does display the driver "MS-SQL Server Using MS Generic Driver With Windows Authentication" with a green check mark in the list of installed drivers.

Do we need to install "MS-SQL Server Using jTDS Driver With Windows Authentication" instead ? Or is there another issue ?

Thank you !

[star_lord]

Hi @performancemoni 

I know this answer is a bit late, but maybe it will help others that run into this issue.  The "MS-SQL Server Using MS Generic Driver With Windows Authentication" is only supported when DB Connect is running on a Windows server.  Try Kerberos authentication instead.

https://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Installdatabasedrivers#Microsoft_SQL_Serv...