Error to install ODK Aggregate with SQL Server

Support
1

Hi.
I am configuring ODK Aggregate with SQL Server and Windows 7.
I was unable to deploy properly with tomcat.

I hope you can help me.

Attach my settings.

image

Logs.txt (7.3 KB)

image

image

image

image

image

2

Of the 3 jars, sqljdbc4-4.1, sqljdbc41 and sqljdbc42, you should only have
one. Either sqljdbc42.jar if using Java 8, or sqljdbc41.jar if using Java
7. And if you want to connect to Azure SQLServer, you must use Java 8.

Are you using the 1.4.13 installer?

The connection URL for the jdbc database connection,
https://www.microsoft.com/es-es/download/confirmation.aspx?id=11774
Is also incorrect. This should be something of the form:

jdbc:sqlserver://127.0.0.1
\MSSQLSERVER:1433;databaseName=odk_unit;applicationName=ODKAggregate;encrypt=true;trustServerCertificate=true;integratedSecurity=true;authentication=ActiveDirectoryIntegrated;

If you use the 1.4.13 installer, it will assemble this connection URL for
you.

··· On Wed, Mar 15, 2017 at 2:34 PM, wrote:

Hi.
I am configuring ODK Aggregate with SQL Server and Windows 7.
I was unable to deploy properly with tomcat.

I hope you can help me.

Attach my settings.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

Of the 3 jars, sqljdbc4-4.1, sqljdbc41 and sqljdbc42, you should only have one. Either sqljdbc42.jar if using Java 8, or sqljdbc41.jar if using Java 7. And if you want to connect to Azure SQLServer, you must use Java 8.

Are you using the 1.4.13 installer?

The connection URL for the jdbc database connection, https://www.microsoft.com/es-es/download/confirmation.aspx?id=11774
Is also incorrect. This should be something of the form:

jdbc:sqlserver://127.0.0.1\MSSQLSERVER:1433;databaseName=odk_unit;applicationName=ODKAggregate;encrypt=true;trustServerCertificate=true;integratedSecurity=true;authentication=ActiveDirectoryIntegrated;

If you use the 1.4.13 installer, it will assemble this connection URL for you.

Hi.

I am configuring ODK Aggregate with SQL Server and Windows 7.

I was unable to deploy properly with tomcat.

I hope you can help me.

Attach my settings.

--

You received this message because you are subscribed to the Google Groups "ODK Developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

Thanks for the orientation Mitch Sundt, at the end use the following connection string:"jdbc:sqlserver://localhost;databaseName=odk_prod;user=odk_prod;password=*****;".
Also in sql server allowed the connection by user and password.
With this configuration has resulted.

··· El jueves, 16 de marzo de 2017, 10:42:24 (UTC-6), Mitch escribió: > On Wed, Mar 15, 2017 at 2:34 PM, wrote:
1 Like
4

Hi, could you please help me deploying odk with sql server?

Kind regards

1 Like
5

Hi, what is the problem...????

2 Likes
7

A post was merged into an existing topic: Connecting SQL JDBC