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

[Jim Knepley - ReleaseTEAM · Accepted solution]

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