Unable to Connect to AWS RDS PostgreSQL: SSL Must Be Enabled

Unable to Connect to AWS RDS PostgreSQL: SSL Must Be Enabled

A connection to an AWS RDS PostgreSQL instance cannot be established from dbForge Studio for PostgreSQL, while other database tools, such as PgAdmin or DBeaver, connect successfully using the same connection parameters.

Cause

AWS RDS PostgreSQL requires SSL connections. In dbForge Studio for PostgreSQL, SSL is disabled by default (SSL Mode = disable). As a result, the connection attempt fails if the server accepts only SSL-encrypted connections. Other database clients, including PgAdmin and DBeaver, typically use SSL Mode = prefer by default. They first attempt to establish an SSL connection and automatically fall back to a non-SSL connection only if SSL is unavailable.

Resolution

When creating or editing the connection:
  1. Open the Security tab.
  2. Enable the Use SSL protocol option.
  3. Save the connection settings and reconnect.
If the server requires certificate validation or a specific SSL mode, configure the corresponding SSL parameters according to the AWS RDS PostgreSQL settings.

Screenshot of the Security tab with the Use SSL protocol option enabled:


    • Related Articles

    • Using SSL with dotConnect for PostgreSQL from NuGet

      When using dotConnect for PostgreSQL via NuGet packages, note that SSL support is not included in the NuGet assemblies by default. To enable SSL connections, you must manually add the necessary assemblies from the full Devart installation package to ...

    • TLS 1.3 Support on Windows 10 with MySQL and PostgreSQL

      Issue When connecting to MySQL or PostgreSQL servers on Windows 10, you may encounter errors if the server is configured to use only TLS 1.3. However, the connection succeeds if TLS 1.2 and TLS 1.3 are both enabled. Reason Windows 10 does not support ...

    • Unable to Connect Using macOS DSN Configuration

      If you’ve installed an ODBC driver on macOS but can’t proceed with setting up a DSN because the iODBC Data Source Administrator app is missing, here’s how to resolve the issue. Step 1: Install iODBC Manager To test and manage ODBC connections on ...

    • Password visible in Connection string ODBC PostgreSQL

      When connecting to a PostgreSQL database using ODBC, you may encounter a situation where the password is visible in the connection string in Microsoft Excel. Unfortunately, we do not have the ability to alter how Excel handles or displays this ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...