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
- Download the jtds-*.jar file any latest version
- Copy it to Jboss_HOME://server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/jtds1.2-5.jar
- 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