qstudio icon indicating copy to clipboard operation
qstudio copied to clipboard
verified publisher icon timeseries

Using integrated security with MS SQL Server

Open dmonder opened this issue 2 years ago • 8 comments

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?

dmonder avatar Dec 12 '23 17:12 dmonder

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.

unnamed

unnamed-1

Then in qStudio/Pulse use connection settings like this: unnamed

ryanhamilton avatar Dec 12 '23 17:12 ryanhamilton

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

dmonder avatar Dec 12 '23 17:12 dmonder

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 https://github.com/microsoft/mssql-jdbc/issues/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?

ryanhamilton avatar Dec 12 '23 18:12 ryanhamilton

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 avatar Dec 13 '23 00:12 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?

dmonder avatar Dec 13 '23 16:12 dmonder

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.

ryanhamilton avatar Dec 13 '23 17:12 ryanhamilton

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: @.***>

dmonder avatar Dec 16 '23 00:12 dmonder

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

brenthuisman avatar Jun 04 '24 09:06 brenthuisman