MyTechReference - Technical Notes

by IDAMGroup

Setup Aveksa Collector to authentication using Windows Authentication

Setup MSSQL Server connection  using Windows Authentication

To setup aveksa collector to connect to MSSQL Server using Windows authentication.

2 ways to connect to MSSQL Server to collect data

SQL Authentication

SQL Authentication is straight forward to setup in Aveksa Collector.

Windows Authentication

  1. Download the jtds-*.jar file  any latest version
  2. Copy it to  Jboss_HOME://server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/jtds1.2-5.jar
  3. restart the application

acm restart

Setup collector

Login to Aveksa

Collector–>Account/Entitlement collector –> Create Collector


Collector Name:     Test MSSQL

Data Source Type: Database

DB Type: jTDS

Driver Class:









Disclaimer: Content posted here worked for me and may not guarantee success, should be used as reference only and please use it cautiously.