In this article, we'll go over how to enable SQL Server Integrated Security in Analyze for database nodes.
- 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) - Run the .exe to extract the files to a local folder on your PC.
- 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. - 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. - Update the database node's
DbDriverClasspath
to the directory location from Step 4. - Append
integratedSecurity=true
toDbUrl
orDbOptions
, if it isn't present already. - Re-run the Node
Comments
0 comments
Please sign in to leave a comment.