Automic Workload Automation

Expand all | Collapse all

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

  • 1.  Analytics v12: how to connect to MSSQL using Windows authentication only

    Posted 01-03-2017 10:05 PM
    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


  • 2.  Analytics v12: how to connect to MSSQL using Windows authentication only

    Posted 03-16-2017 12:41 PM
    Thanks a lot for the information