peter_grundler_automic

Analytics v12: how to connect to MSSQL using Windows authentication only

Discussion created by peter_grundler_automic on Jan 4, 2017
Latest reply on Mar 16, 2017 by Tobias_Stanzel_241
  1. Add the parameterintegratedSecurity=true to the connection string in your file application.properties (similar to the JWP configuration)
  2. Don't specify a username or password for parameters "datasource.ae.***"
  3. Copy the filesqljdbc_auth.dll(part of MS JDBC download package) into any folder
  4. Add this folder to the java library path, i.e. the start command for Analytics should look like
    java.exe -Xrs -Xms512m-Djava.library.path=C:\Automic\AutomationEngine\bin\-jar analytics-backend.jar
  5. Start Analytics

Outcomes