We would like to confirm that we do not support Windows Authentication credentials during Adeptia Installation process. To configure Adeptia Suite to use MS SQL as Log database with windows authentication(domain user)follow below steps:
1. Install Adeptia using “Express” installation. After installing, you can manually point your Log Database to SQL server.
2. Move the embedded Log database to the SQL server database by following the below forum post:
http://support.adeptia.com/entries/21925722-moving-log-database-on-sql-server-mysql-oracle
3.Now provide the following values for Database Appender in server-configure.properties file:
A) In the "log4j.appender.jdbc.url" property provide the following as url:
"jdbc:jtds:sqlserver://<DatabaseServer>:1433/<DatabaseName>;domain=domain_name"
B) In the "log4j.appender.jdbc.dbclass" property provide "net.sourceforge.jtds.jdbc.Driver" as driver name.
C) In the "log4j.appender.jdbc.username" property provide the username of the domain_user.
D) In the "log4j.appender.jdbc.password" property provide the password of the domain_user.
4. Restart the Kernel and Web-runner.
Comments
1 comment
If you are using NTLM, you'll need to append the proper string to the URL
"jdbc:jtds:sqlserver://<DatabaseServer>:1433/<DatabaseName>;domain=domain_name;useNTLMv2=true;"
Article is closed for comments.