How to enable SQL Server Integrated Security within database nodes in Analyze

In this article, we'll go over how to enable SQL Server Integrated Security in Analyze for database nodes.

1. Download sqljdbc_6.0.8112.200_enu.exe from https://www.microsoft.com/en-us/download/details.aspx?id=11774 (NOTE: This is for if you have SQL Server 2008 - 2016)
   
   
   
   
2. Run the .exe to extract the files to a local folder on your PC.
3. Within those folders, take the sqljdbc_auth.dll from .../enu/auth/x64 and place it in your <analyze main install>/lib/windows-x86-64 directory.
4. Copy the sqljdbc42.jar from .../enu/jre8/ into any new directory outside of the Analyze install, site, and data directories. This is for preservation after upgrades.
5. Update the database node's DbDriverClasspath to the directory location from Step 4.
6. Append integratedSecurity=true to DbUrl or DbOptions, if it isn't present already.
7. Re-run the Node