Connect Adeptia to MS SQL log database

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.

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    David Paras

    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.