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

http://aveksa.mytechref.com/aveksa

Collector–>Account/Entitlement collector –> Create Collector

Collector Name:     Test MSSQL

Data Source Type: Database

DB Type: jTDS

Driver Class: class.net.souceforge.jtds.jdbc.driver

URL:jdbc:jtds:sqlserver://<host>:<port>/database;useNTLMv2=true;domain=xyz

username:

password

---------------------------------------------------------------------------------------------------------------------------------------------

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