'Remote connections to this server are not allowed' error when attempting to connect to H2 database in Confluence Server
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When attempting to connect remotely to the embedded H2 database in Confluence Server the following exception is thrown:
Connection to jdbc:h2:tcp://myserver.com/myconfluence/localhome/database/h2db failed.
Remote connections to this server are not allowed. Cause
Remote connections to the embedded H2 database are not permitted for security reasons. You can only connect to H2 from the server on which Confluence is installed.
Resolution
Connect to the embedded H2 database from the server on which Confluence is installed, as described in Embedded H2 Database.
Note: Plugin vendors can connect remotely to the embedded H2 database when Confluence is running in dev mode, but administrators should not use this as a workaround, and instead should migrate to a supported external database.