# How to resolve Sprinto check for enabling data encryption on Azure SQL Database

### About:

Sprinto check: Ensure that 'Data encryption' is set to 'On' on a SQL Database

The above-mentioned Sprinto check verifies that data encryption is enabled for your Azure SQL databases. Data encryption helps protect your data at rest by encrypting the database files on the storage level.

### Purpose:

This check ensures that your Azure SQL database data is encrypted at rest, providing an additional layer of protection against unauthorized access or data breaches. Enabling data encryption can safeguard sensitive information stored in your SQL databases, even if the underlying storage is compromised.

### How to fix this check:

Follow the below steps to resolve this check:

#### Before you begin

* Ensure you have administrator privileges to manage Azure SQL database configuration.

#### Enabling Data Encryption

1. Log in to the [Azure Portal](https://azure.microsoft.com/en-in/get-started/azure-portal) using your credentials.
2. Navigate to the SQL Databases service.
3. Select the SQL Database from the list for which you wish to configure.
4. Click on Date Encryption under Security from the left-side navigation bar.
5. On the Transparent date encryption tab, review the data encryption status. If it shows "Unencrypted,” turn on the data encryption option. Click Save to apply the changes.![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72098963476/original/eCi4qOWf-XTlURIeyKBVROlf9KpGGDJqcQ.png?1716367554)

   <figure><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/72098963477/original/z7M7nRAFfXD-DfVvET7BcaEpm-hSDca2tQ.png?1716367555" alt="" width="563"><figcaption></figcaption></figure>
6. Repeat the above steps for each SQL Database that stores critical data.&#x20;

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

Contact [Sprinto support](mailto:www.support@sprinto.com) if you have any queries related to the check or need assistance.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sprinto.com/monitors/encryption-and-backup-monitoring/how-to-resolve-sprinto-check-for-enabling-data-encryption-on-azure-sql-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
