> For the complete documentation index, see [llms.txt](https://docs.sprinto.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sprinto.com/monitors/encryption-and-backup-monitoring/how-to-resolve-sprinto-check-for-enabling-data-encryption-on-azure-sql-database.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` 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>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.
