Microsoft SQL Server 2016

Camunda 7 Topics Discussion & Questions
1

We are using MS SQL Server 2016 as our primary database server. Ist it possible tu use this database for camunda. If so, are there any requirements?
For testing purposes, we use a postgres DB, wich work fine. But in the production environment, this is no opinion.

Thanks for any support!

2

Hi Thomas,

currently Camunda officially supports SQL Server 2008 R2, 2012 and 2014. We haven’t tested SQL Server 2016 yet but I wouldn’t expect any breaking changes there. So feel free to give it a try and report any issue you encounter. Please see the specific configuration notes for SQL Server which probably also apply for 2016.

Cheers,
Sebastian

3

Any Document for How to Configure camunda with sql server

4

Hi
Am trying to connect camunda with Microsoft SQL Server. Am able to establish a connection with Microsoft SQL Server 2014 but not with Microsoft SQL Server 2016. Does this only support with Microsoft SQL Server 2008 R2/2012/2014?. Can anybody help?

5

Hi @ebinsleeba,

this depends on the Camunda version that you are using.
As stated on this page in the documentation, the latest version of Camunda (7.11) definetly supports SQL Server 2016.

Which version of Camunda are you using?

Regards
Michael

6

Hi MichiDahm,
Am using Camunda (7.11) and still not able to connect with MSSQL 2016. Do I need to change the sqljdbc right now am using sqljdbc4.jar. If so which version should I use?

7

SQLJDBC4 4.0 is also the version used by Camunda itself. This definitely should work.
Newer versions of the JDBC driver should work fine also, I usually prefer to use the latest released version.
https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4/4.0
https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/7.2.2.jre8

8