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

Peter GrundlerPeter Grundler Team Automic Posts: 134 Specialist ✭✭✭✭
  1. Add the parameter integratedSecurity=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.xxx"
  3. Copy the file sqljdbc_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

Comments

Sign In or Register to comment.