0

I am trying to configure activiti to communicate ms-sql 2014 with windows authentication instead of with username/password in connection url.
What i have done ?

  1. downloaded JDBC Driver, put sqljdbc4-3-0.jar in JAVA_HOME and in the web-info\lib
  2. put sqljdbc_auth.dll (64bit) in C:\Windows\System32
  3. set integrated security in db.properties as following:

db.properties (C:\Workflow\apache-tomcat-7.0.62\webapps\activiti-explorer\WEB-INF\classes): 

db=mssql
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://127.0.0.1:1433;databaseName=activiti;integratedSecurity=true;

When using regular authentication (I remove the integratedSecurity=true and add user=XXX and password=XXX it works!)

When I open log the last line is: 

DEBUG org.springframework.jdbc.datasource.SimpleDriverDataSource: Creating new JDBC Driver Connection to [jdbc:sqlserver://localhost;databaseName=activiti;integratedSecurity=true;]

Then the java application shutsdown and i see hs_err_pid4232.log as attached with exception: 

 EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000061a3cf13, pid=4232, tid=8080

What can cause this not to work ?
I want thinking maybe it did not load the DLL/JARS it should be in order to use JDBC driver ? the sql server config looks like this:
enter image description here

The log of process crush is at: http://pastebin.com/xpW5yvEP

ilansch
  • 4,784
  • 7
  • 47
  • 96
  • 1
    Where did you get the sqljdbc4-3-0.jar and sqljdbc_auth.dll files from? I found a JAR with the same name as the JAR you mention [here](https://code.google.com/p/power-architect/source/browse/branches/1.0.0-preview-release-03/jdbc_drivers/?r=3975), and that implies that sqljdbc4-3-0.jar is quite very old. Do you get the same behaviour if you use the latest version of the MS JDBC driver JAR and authentication DLL, available from https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 ? – Luke Woodward Dec 20 '15 at 15:42
  • Thank you everything works now, I received the old jars as legacy and since the name was 4-3 and the latest i downloaded were 4.2 I was confused, who knew 4.2 is newer than 4-3-0. the auth.dll i used latest version, but the jar was not the latest. – ilansch Dec 21 '15 at 07:58

1 Answers1

1

This error screams "trouble with the authentication dll". Try these steps:

  • Download latest sqljdbc, unzip it locally from here: https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

  • put the .jar in your classpath and the .dll in your library path. Try using a "real" path by adding -Djava.library.path=PATH/TO/DLL into your startup.

  • run java -fullversion to make sure you have the right .dll (32 bit vs 64 bit) installed there.

  • run program again.

Jan
  • 13,738
  • 3
  • 30
  • 55