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

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.





Comments