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; } } }

How to connect to a database on a SQL server host with Force Encryption enabled?

Alfredo Lagrosa

Hi,

How can I create a profile in the SQL for Confluence app that will connect to a SQL server host that has Force Encryption enabled?

I'm using the values below,

Profile name: Force Encrypt
Data source name: none
Setup type: By connection string
Connection string: jdbc:jtds:sqlserver://server1:1433/database1?ssl=true
Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver JAR location: confluence/WEB-INF/lib/mssql-jdbc-12.8.1.jre11.jar
~~~~~~~
Error message received is "I/O Error: DB server closed connection"

Accepted answers

Alfredo Lagrosa

Opened a Microsoft support case,
Discovered I needed to update our Data Source Profile's connection string to use the FQDN of the SQL server that has enforce encryption enabled.
The registered secure certificate on our SQL server is also using the FQDN.
Yet, with enforce encryption disabled, the Data Source Profile does not need the FQDN. Go Figure?!

All comments

Shawn Doyle - ReleaseTEAM

Hi @Alfredo Lagrosa

This document may help. https://confluence.atlassian.com/confkb/cannot-connect-confluence-to-ms-sql-server-using-force-encryption-591594220.html

It comes down to modifying the start parameters for Confluence.

Alfredo Lagrosa

Hi @Shawn Doyle - ReleaseTEAM ,

initially, I was going to reply I already tried the recommended resolution, below, in that doc, but, our Data Source profiles are still unable to connect to that SQL server.

jdbc:jtds:sqlserver://YourConfluenceServer:1433/YourConfluenceDatabase?ssl=true

Yet, there appears to be other recommendations in that doc that I will explore.
Sorry, if that was not clear earlier.

Also, opened a support ticket with Appfire, the vendor for SQL for Confluence (Pro Edition), which we are using to create our SQL Data Source profiles.

Also, was able to create a new Data Source profile that can connect to another SQL Server that has forced encryption enabled. The SQL servers, upon a quick review, found

Data Source profile can connect to SQL 2019 Enterprise on Windows 2022 standard with forced encryption enabled.

Data Source profile can not connect to SQL 2019 Standard on Windows 2019 standard with forced encryption enabled.

Thank You!

Alfredo Lagrosa

Another possible Connection string to use on a SQL Server forcing client connection encryption,
jdbc:jtds:sqlserver://yoursqlserver:1433/yourdatabase;TrustServerCertificate=True;

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

data-center

addon-org.swift.confluence.sql

confluence-data-center

encryption