---
title: "About Azure SQL Database prerequisites"
slug: "about-azure-sql-database-prerequisites"
description: "Learn what's needed to connect Supermetrics to Azure SQL Database."
updated: 2025-06-26T12:41:22Z
published: 2025-06-26T12:41:22Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# About Azure SQL Database prerequisites

Before you can [begin using Azure SQL database as a Supermetrics destination](/v1/docs/how-to-configure-an-azure-sql-database-destination), you should ensure that you've met the prerequisites below.

Note that items from Azure Synapse — for example, database names or database schemas — aren't compatible with Azure SQL destinations.

## Prerequisites

### SQL server

You need an existing SQL Server in Azure, and a database set up for that server.

### Permissions

If you'd prefer to create the destination with a user account, make sure it has permission to:

- Access and ability to create, query, update, rename, drop, insert and delete from objects in a given schema within a database. [Learn more about GRANT (Transact-SQL)](https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-ver16).
- Query table and column metadata information. [Learn more about System Information Schema Views (Transact-SQL)](https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-ver16).

Alternatively, you can use your SQL Server Admin login credentials to create the destination on the [Supermetrics Hub](https://hub.supermetrics.com/).

### IP allowlisting

If your organization only allows access from “selected networks”, [you need to add the Supermetrics IP addresses to the Firewall settings](/v1/docs/about-ip-address-allowlisting-for-data-warehouse-destinations) in your SQL Server.

[Learn about the permissions you need to modify in Firewall settings](https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql-db#permissions).

Go to **Networking → Connectivity → Connection Policy**, and set the connection policy to "Default" mode. [Learn more about connection policy in Azure SQL Database](https://learn.microsoft.com/en-gb/azure/azure-sql/database/connectivity-architecture?view=azuresql#connection-policy).

## More resources

- [How to configure an Azure SQL Database destination](/v1/docs/how-to-configure-an-azure-sql-database-destination)
- [How to create a destination](/v1/docs/how-to-connect-to-a-data-warehouse-destination)
- [How to create a transfer](/v1/docs/how-to-create-a-transfer)