SQL Server Driver (Kerberos authentication?)

wdchristensen — Tue, 28 Dec 2021 20:09:25 GMT

I am using QS April 2018 and I am having issues connecting to a SQL Server using the SQL Server specific driver with pass through authentication (Active Directory). I can connect to the problem SQL Server using ODBC and OLE DB using AD however there is a bug which causes these drivers not to recognize the “Date” datatype correctly (note: datatime datatypes work as expected). Unfortunately, OLE DB and ODBC drivers read the date fields as a string. My guess is that SQL Server need to use Kerberos authentication. When I run the command below I will get “KERBEROS” on the server that works and I will get “NTLM” on the one that doesn’t.

select auth_scheme from sys.dm_exec_connections where session_id=@@spid

https://support.microsoft.com/en-us/help/909801/how-to-make-sure-that-you-are-using-kerberos-authentication-when-you-c

I don’t want to trial and error my way through this issue if I can avoid it. Any help you can provide would be greatly appreciated! Thanks

Re: SQL Server Driver (Kerberos authentication?)

Andre_Sostizzo — Wed, 12 Feb 2020 16:13:07 GMT

The problem may seem less to do with authentication but what method is used to connect to the SQL Server in order to satisfy the authentication method. The problem reported is likely to be related to what is documented under Field tagging for source data with unrecognized formatting has changed in February 2019

topic Re: SQL Server Driver (Kerberos authentication?) in Connectivity & Data Prep

SQL Server Driver (Kerberos authentication?)

Re: SQL Server Driver (Kerberos authentication?)