Question 105816 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – SSL connection is required. Please specify SSL options and retry – postgresql using dbforge

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

Tags:

2

Answers


  1. 0
    • 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.

    Login or Signup to reply.
  2. 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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search