How to resolve Sprinto check to enable the SSL connection enforcement on Azure PostgreSQL Database server

About:

Sprinto check: Ensure 'Enforce SSL connection' is set to 'ENABLED' for PostgreSQL Database Server

The above-mentioned Sprinto check verifies that the "Enforce SSL connection" setting is enabled for your Azure Database for PostgreSQL servers. This setting ensures that all connections to the PostgreSQL server are encrypted using Secure Sockets Layer (SSL) protocol.

Purpose:

The purpose of this check is to enforce secure communication between client applications and your Azure Database for PostgreSQL server. By enabling the "Enforce SSL connection" setting, you can protect sensitive data from being intercepted or tampered with during transmission. This measure helps maintain data privacy and integrity, ensuring that only authorized clients can establish secure connections to your PostgreSQL database.

How to fix this check:

Follow the below steps to resolve this check:

Before you begin

• Ensure you have the administrator privilege to manage Azure Database for PostgreSQL server configuration.

Enabling SSL Enforcement

1. Log in to Azure Portal using your credentials.

2. Navigate to PostgreSQL Database service.

3. Select the database from the list you wish to configure.

4. Click Connection Security under Settings.

5. Review the SSL enforcement status. If it's disabled, enable it.

6. Click Save to apply the changes.

7. Repeat the above steps for all databases that store critical organizational data.

Sprinto will detect the configuration change and set the check status to "Passing.”

Contact Sprinto support if you have any queries related to the check or need assistance.