![]() ![]() In production, you should properly setup your certificates, but that's not in the scope of what's being asked here. Also, please make sure you know what you're doing if you leave "trustServerCertificate=true " in the URL. If you leave the drop down next to URL on "default", it will attempt to use a user name/password, which is not what you want if you're using integrated authentication. Picture of General tab in Project Data Sources Then, on the general tab, make sure to change the drop down menu next to the URL, to "URL only" and put in a URL of the form: jdbc:sqlserver:// database=testdatabase integratedSecurity=true authenticationScheme=JavaKerberos encrypt=true trustServerCertificate=true Picture of Advanced tab in Project Data Sources showing authentication scheme Picture of Advanced tab in Project Data Sources Make sure to set the jdbc driver to use integrated security and Java Kerberos. Note that I did not have to do "Step 2: Configuring KDC in nf". If you have a Kerberos ticket, you should see: Aug 29 12:17:34 2018 Aug 29 22:17:34 2018 used this article on Connecting using ActiveDirectoryIntegrated Authentication Mode to troubleshoot this. The command above will make the ssh server listen on port 8080, and tunnel all. (First, I'm assuming you have Kerberos working. If you have access to a remote SSH server, you can set up a remote port forwarding as follows: ssh-R 8080:127.0.0.1:3000 -N -f email protected Copy. I was able to connect on MacOS in Intellij 2018.2 using the Microsoft 7.0.0 SQL Server jdbc driver. When going into a SQL Schema Compare window, choosing database, Select Connection, and then Browse, the Authentication dropdown initially lists Windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |