nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MSSQL Database Authentifcation failed for Confluence-DC (Container)

Philip Keidel

Hi everyone,
I am in the process of deploying Confluence Data Center in a containerized environment. I am using the image of Atlassian “atlassian/confluence:8.5.17” based on Ubi8. Confluence starts, but it cannot connect to an MSSQL32 database (external, not in container).

I use the following JDBC URL: jdbc:sqlserver://:;databaseName=;integratedSecurity=true;encrypt=true;domain=LAN

User: LAN\<user>
PWD: <pwd>

The JDBC MSSQL 12.6.3 driver is located in the container: /opt/atlassian/confluence/confluence/WEB-INF/lib/

Following error occurs when trying to setup the database connection

Accepted answers

Jim Knepley - ReleaseTEAM

Hi @Philip Keidel, welcome to the community.

Your JDBC connection URL can specify authentication properties, which is probably what you need to do. The exact details of authentication will depend on the database server configuration.

ref: https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

All comments

Jim Knepley - ReleaseTEAM

Hi @Philip Keidel, welcome to the community.

Your JDBC connection URL can specify authentication properties, which is probably what you need to do. The exact details of authentication will depend on the database server configuration.

ref: https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

Philip Keidel

Hi @Jim Knepley - ReleaseTEAM

thanks for your fast reply. What authentication properties do you have in mind? Aren't the properties "integratedSecurity=true" and "encrypted=true" sufficient?

And the lines "driver not configured for integrated security" and "unable to load dll file" are not the reason why the connection fails?

Jim Knepley - ReleaseTEAM

Unfortunately, the best answer I can give you is "it depends." MSSQL supports a variety of authentication mechanisms, your SQL administrator can tell you which one to use.

You can try the "user" and "password" properties, which would apply to Kerberos and ActiveDirectoryServicePrincipal connections.

Philip Keidel

Hey @Jim Knepley - ReleaseTEAM

thanks for your help, I really appreciate that! The connection to the MSSQL-Database is now working. I had to use Integrated Authentication over Kerberos (creating krb5.conf & adding to jvm-properties). Described in: Use Integrated Authentication over Kerberos when connecting to MSSQL on Linux in Jira | Jira | Atlassian Documentation

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

database

container

database-connection

mssql