search

azimuttapp / azimutt

Explore, document and optimize any database
https://azimutt.app
MIT License
1.36k stars 87 forks source link

Can't connect to SQL Server Database with Integrated Authentication / Kerberos #291

Open frederic-luce opened 7 months ago

frederic-luce commented 7 months ago

I tried to connect to a SQL Server Database using kerberos authentication from a Linux host. Connection string I use is : Server=XX.XX.XX.XX,1433;Database=YYYYYY;trustedConnection=true;trustServerCertificate=true (host name resolution didn't work) returned error is : http://localhost:4177: Login failed for user ''.

It seems that the trustedConnection parameter is completly ignored.

Is integrated authentication on SQL Server Database supported by the gateway ?

loicknuchel commented 6 months ago

Hi @frederic-luce Thanks for raising this. The authentication part is handled by the connector, can you try to run the connect.test.ts and see how it goes? If you can find a working setup (with the second test), I can make the change in the connector. (as I don't have an SQL Server with kerberos, I can't test on my side) Or we can setup a meeting to debug this together if you want. In any way, you will have to checkout the repo and run the JS test on your machine.