topic Re: DB Connect 2 connection is not using integrated authentication with SQL Server in All Apps and Add-ons

DB Connect 2 connection is not using integrated authentication with SQL Server

trevorgould — Wed, 06 May 2015 23:36:11 GMT

I have set up an identity (with username: MYDOMAINNAME backslash myusername) and a sql server connection (MS-SQL Server using generic driver) but am getting an error when a connection is attempted.

I can log onto the SQL Server itself with SSMS and see in the logs that the login is failing with this error:

Reason: Attempting to use an NT account name with SQL Server Authentication

I see no way in the DB CONNECTION 2 configuration screen to specify to use Integrated Authentication. From posts I've read here, entering the username in the form domain\username will cause it to use integrated authentication, but that seems to not be the case.

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

halr9000 — Thu, 07 May 2015 02:39:36 GMT

Looking at posts like this one, I think they are DB Connect v1, which was a different codebase. It's possible that this is done differently in v2, but I don't know the right answer.

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

Richfez — Thu, 07 May 2015 13:42:34 GMT

I haven't had time to investigate further, but in initial testing we also had some serious problems with DB Connect 2 using integrated authentication. We could not seem to make it work regardless of how we configured things.

We have 20 or 30 inputs of various sorts (both integrated and local auth) against SQL server in DB Connect v1 with nary a problem. But in v2, we can't get a one of those to work no matter how we try to configure them. Switching those inputs to a local SQL auth works perfectly regardless of v1 or v2.

Not an ideal solution, but again, we haven't had the time to look into it further and we'll get it working before we start actually deploying things using v2.

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

halr9000 — Thu, 07 May 2015 16:03:18 GMT

I learned later last night that this is a known issue with dbx2, and a workaround should be posted within a few days.

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

bosburn_splunk — Thu, 07 May 2015 16:13:46 GMT

Documentation has been updated on how to set up integrated authentication:
DBX V2 Troubleshooting - Windows Authentication

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

trevorgould — Fri, 08 May 2015 03:58:15 GMT

So is V1 just fine or are there feature/performance benefits to V2 that one should wait for?

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

trevorgould — Fri, 08 May 2015 18:13:06 GMT

To be clear: This is for the jTDS driver driver as opposed to the Microsoft driver, correct?

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

jcoates_splunk — Sat, 09 May 2015 22:50:35 GMT

This is a deep pile of issues, so I'll try to summarize.

DB Connect 1.1.x with Java 7 and the jTDS driver should work for your use case. However, Java 7 is now out of support by Oracle, and you should really be considering how to get off of it.
DB Connect 1.2.x requires Java 8, but that breaks the jTDS driver. That's actually okay because the Microsoft JDBC driver performs better and has more features, and should be able to do this.
DB Connect 2.0.x also requires Java 8 and Microsoft JDBC driver, but we messed up the ability to use Windows authentication instead of SQL authentication. That's getting fixed soon.... if you're desperate and on Windows there's a complex work-around that should really involve a support ticket.

Re: DB Connect 2 connection is not using integrated authentication with SQL Server

jcoates_splunk — Sat, 09 May 2015 22:52:06 GMT

yes, the driver's mentioned in the jdbc url... but it will only work with a DBX 2 install, not a DBX 1.2 install.