How can I use MS SQL Server's Integrated Authentication in IntelliJ IDEA 12?
intellij-idea, mssql-jdbc, sql-server
Solution
I have 64 bit Windows 7.
Solution steps
- Switch to using the 64bit IntelliJ IDEA executable.
- Figure out which installed 64bit JDK IDEA is loading on startup (the version is given in Help->About)
- copy the `sqljdbc_auth.dll` file to the JDKs jre\bin\ folder
File Locations on my machine: (NOTE: I'm not sure which location is truly correct.)
- `C:\Program Files\Java\jdk1.7.0_05\bin\` <-- Current version of Java IntelliJ IDEA is using.
- `C:\Windows\System32`
Problem
I have several database connections configured in IntelliJ IDEA. I'm connecting to MS SQL Server 2000/2005. The connections use Integrated Authentication, with the SQLJDBC4 driver. I have the sqljdbc_auth.dll file in the same directory as the sqljdbc4 driver. My configuration worked in IntelliJ IDEA 10.5.4 I just recently upgraded to 12.1.2 and now my connections throw an error about not being properly configured for Integrated authentication and that the driver cannot find the sqljdbc_auth.dll file. So how can I add the sqljdbc_auth.dll file as one of the files to be loaded for my jdbc connections?