We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Articles in this section

See more

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

Avatar
Ryan Klaproth
  • Updated
Follow

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)

    2020-11-11_14_16_35-Download_Microsoft_JDBC_Driver_6.0_for_SQL_Server_from_Official_Microsoft_Downlo.png

  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

Related articles

Comments

0 comments

Please sign in to leave a comment.