Update JDBC driver with Integrated Security

[Victor Prasad]

Hello,

We were using the jtds driver before our upgrade.

Now we need to upgrade

We currently use a service account on the domain.

Does anyone know the correct syntax to use to make it work?

The old jtds still works:

<property name="hibernate.connection.url">jdbc:jtds:sqlserver://<dbserver>:<port>/ConfluenceDb;instance=<conf>;domain=<corp>;useNTLMv2=true</property>

The jdbc driver is configured like this but Confluence will not start:

  <property name="hibernate.connection.url">jdbc:sqlserver://<dbserver>:<port>;IntegratedSecurity=true;database=ConfluenceDb;instance=<conf>;domain=<corp>;useNTLMv2=true</property>

 Update:

I have tried using:

<property name="hibernate.connection.url">jdbc:sqlserver://<dbserver>;<portl>database=ConfluenceDb;instance=conf;domain=corp;useNTLMv2=true</property>

And getting and error that the domain account that the login failed for the user.  But the DBA thinks it is trying to login as an SQL login, not and integrated user.

Error:

Login failed for user 'confluence'. ClientConnectionId:5afedcf3-22a6-4450-be7a-3a4ab00d070b

[Victor Prasad]

from the kind folks at Confluence support:

switch from jtds to jdbc - Confluence Support - Service Desk

• • Download and extract sqljdbc_auth.dll from Microsoft JDBC Driver 6.0 for SQL Server
  • If you are running a 64-bit JVM on an x64 processor, copy the sqljdbc_auth.dll file to the x64 folder.
  • Add the following to the JVM argument and restart Confluence in order for it to use sqljdbc_auth.dll -

    -Djava.library.path=C:\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_<version>\enu\auth\x64

    Please check our documentation on Configuring System Properties for more details.

[Victor Prasad]

Update.

I took out the integrated security part - getting a login error - better than before!