0

I have enabled Azure Postgresql SSL connection mode and after doing that I was not able to connect to Postgres database using dbForge, it is showing that SSL connection is required. Please specify SSL options and retry. I can able to access the database from .NET application by including the below parameters in the connection string. Also I can able to connect to the database from pgAdmin.

Ssl Mode=Require;Trust Server Certificate = true;

If I provide the same parameters dbForge it is not connecting and shows keyword not supporting.

enter image description here

Harshitha Veeramalla
  • 1,515
  • 2
  • 10
  • 11
Abhishek Hotte
  • 21
  • 9

2 Answers2

0

The cause of the issue is incorrect configuration. You should not set the trust server certificate as it is shown below:

enter image description here

Instead, select the keys from the list of parameters as shown on the screenshot:

enter image description here

Devart
  • 119,203
  • 23
  • 166
  • 186
-1
  • An option to resolve this error would to disable the SSL requirement for your server connection.
  • As per this MSFT documentation, you can disable using Azure portal by:

Click Connection security. Use the toggle button to enable or disable the Enforce SSL connection setting, and then click Save.

Or by using Azure CLI

You can enable or disable the ssl-enforcement parameter by using Enabled or Disabled values.

SuryasriKamini-MT
  • 771
  • 2
  • 5
  • 1
    If we disable SSL then it will work but the requirement is to enable the SSL at DB server level. Is there any way where I can connect to DB server using dbForge, may be by including additional parameters? – Abhishek Hotte Oct 04 '22 at 11:29