search

timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
420 stars 18 forks source link

Using integrated security with MS SQL Server #18

Open dmonder opened 6 months ago

dmonder commented 6 months ago

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 commented 6 months ago

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

dmonder commented 6 months ago

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

ryanhamilton commented 6 months ago

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?

dmonder commented 6 months ago

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 commented 6 months ago

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 commented 6 months ago

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 commented 6 months ago

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 commented 4 weeks ago

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