I'm unable to set up ODK aggregate on my windows 10 system. I'm trying to install ODK aggregate 1.7 in tomcat 8.5 with SQL server 2017 as database.
Can anyone list out complete step by step process to do it... I have completed all the steps in the documentation but still ODKAggregate service donot start in Tomcat. It says FAIL - Application at context path [ODKAggregate] could not be started.
Thanking you all in anticipation!
Can you find the tomcat log file in your machine and share it here?
Thanks for replying.
Tomcat stderr file is attached for your reference.
stderr.txt (186.7 KB)
It seems you have issues with the jdbc connection.
Which version of JDBC did you provide?
I'm using Microsoft JDBC driver 6.2.2 for this from the below link.
I will try and let you know tomorrow.
As I'm using SQL server 2017, will this work as the documentation says that this driver is supported till SQL server 2016.