Cannot connect to Microsoft SQL Server with Window Authentication on MacOS
M2 Macbook Pro running Sequoia 15.2
DataGrip 2024.3.3
Microsoft SQL Server 2016 (13.0.7050.2) running in Azure (no admin access)
I am unable to set up a connection to our MSSQL database via DataGrip (or IntelliJ). It uses Windows Authentication. My corporate domain account is integrated to my corporate Microsoft account. Connection to this database just works in Azure Data Studio with the following config, and nothing changed in the advanced tab:
I have tried the jdbc:sqlserver driver with Kerberos and all of the AAD authentication options.
I have also tried the jdbc:jtds:sqlserver driver with Kerberos and Domain account auth. With both i have tried a lot of the different changes in the advanced tab that are suggested in many other forums but none seem to help.
Does anyone have any insight on this
请先登录再写评论。
For anyone that comes across I found the issues:
1. I had to set the “realm” in the advanced tab. Honestly, don't know why but to get it, run klist in the terminal and it will be what comes after the @ in the ticket principle (e.g if your principal is krbtgt/DOMAIN.ADDR.COM@DOMAIN.ADDR.COM your realm is DOMAIN.ADDR.COM)
2. In the Advanced tab at the bottom under the “Working Directory” field there is an “Expert Options” drop-down. I had to deselect the User IDE Proxy option. I have it set for downloading updates and plugins, but the db is on my internal network so it should not be used. It's worth noting that the db address and the Kerberos realm address were both on the “no_proxy” list but that does not seem to matter.
Other than that, I followed the setup exactly as outlined in the documentation for Kerberos (https://www.jetbrains.com/help/datagrip/db-tutorial-connecting-to-ms-sql-server.html#connect_by_using_kerberos)