Using integrated security with MS SQL Server

[dmonder]

I am trying to use integrated security to connect to my MS SQL Server database but get the error the driver is not configured for integrated authentication. The Microsoft driver is so how to I use that driver?

[ryanhamilton]

Hi David,

Thanks for reporting this issue.

On my machine I needed to do 2 things:

1. Run SQL server on a fixed port
   2.Enable SQL server and windows - mixed mode authentication.

Then in qStudio/Pulse use connection settings like this:

[dmonder]

We do not use local accounts on our SQL Server, only AD accounts. Do you know if this is going to be supported?

[ryanhamilton]

I can't seem to find the official MS driver supporting it:
https://community.streamsets.com/community-articles-and-got-a-question-7/how-to-connect-jdbc-consumer-stage-to-ms-sql-server-via-aad-940
microsoft/mssql-jdbc#696

The JTDS driver does but I would need someone to test that it works and it seems you need to add a few DLLs to your system path:
https://stackoverflow.com/questions/3682852/sql-server-connect-with-windows-authentication

If you are happy to test it, I can have a test version ready in a week, as I myself would need to setup MS SQL and get it working for me first.

What type of AD do you use?

[dmonder]

I am happy to try it when you have it ready. I will look these links over tomorrow and I will post the link to where I found the driver's. Thanks.

[dmonder]

Well, I see the driver link is the same as in the GitHub repository you reference above. I can certainly install a few DLLs wherever they need to go. I am not sure what type of AD we use. What are the choices?

[ryanhamilton]

I also have no idea. Is it Azure? Cloud based? Is it self hosted AD?
Ideally I need exact versions that I could go recreate.

[dmonder]

I would say it is self hosted. David http://www.linkedin.com/in/dmonder “There is no knowing that does not begin with knowing God.” ― John Calvin

…

On Dec 13, 2023, 12:42 PM -0500, Ryan ***@***.***>, wrote: I also have no idea. Is it Azure? Cloud based? Is it self hosted AD? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[brenthuisman]

Same request here: Azure Data Studio requires me to select "Windows Authentication". My credentials don't work (not in ADS either).