# Azure SQL

This procedure explains how to configure an Azure SQL database connection.

Before you begin
: Make sure your database instance is configured to accept incoming connections from the following IP address:
:
:
:
:
: ```
: 63.33.83.29
: ```
:
:
:
: > **Note:**
: > If you are using Datalore On-Premises, its IP address is different. Contact your Datalore administrator for details.

Procedure: Configure an Azure SQL database connection

1. Open the New Azure SQL connection dialog.

In a workspace:

1.  In the sidebar on the Home page, select the workspace where you want to create the connection.

2.

In the workspace resources, select ![Document](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/document.svg) Data and switch to the Databases tab.

![Databases tab](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/ws-databases.png)

3.  Click ![Plus icon](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/plus.svg) New database connection at the top right.

4.

In the dialog, select ![Azure](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/azure.svg) Azure SQL.

![New database connection dialog](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/nb_dialog.png)

In a notebook:

1.  In the sidebar, select ![Attach](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/attach.svg) (Attached data).

2. Switch to the Databases tab.

3.

Click ![Plus](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/plus.svg) New database.

![The Attached data section in a notebook with the Databases tab open](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/database-notebook.png)

4.

In the dialog, select ![Azure](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/azure.svg) Azure SQL.

![New database connection dialog](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/nb_dialog.png)

2. On the General tab, select the connection type.

* default: to connect by specifying the Host, Port, and Database.

* URL only: to connect by providing the URL of a pre-built connection. > **Note:** > Use this method to pass additional parameters. For example, add `&SSL=true` to the URL string to enable SSL.

3. (For default) In Port, enter the port of your Azure SQL database. The default port is `1433`.

> **Note:**
> Real port numbers might be different on your system. Verify that you use a correct port number with your database administrator, server settings, or hosting provider.

4. Under Authentication, select an authentication method:

* User & Password: to use your login and password

* No auth: to connect without authentication required

5. In the User and Password fields, specify your credentials if required by the selected authentication method.

6. Based on the selected connection type:

* In the Database field, type the name of the database to which you want to connect.

* In the URL field, provide the URL of the pre-built connection you want to establish.

7. (Optional) For other options (SSH tunneling, scope inspection, or additional connection parameters), switch to the respective tab of the dialog and follow one of [these procedures](configure-a-database-connection.html).

8. Click the Test connection button at the bottom of the dialog.

9. Once the connection is successfully tested, click the Create and close button.

Procedure: Attach the connection to a notebook

In a workspace:

1. Open the notebook you want to attach the connection to.

2.  In the sidebar, select ![Attach](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/attach.svg) (Attached data) and switch to the Databases tab.

3. Enable the toggle in your database connection.

In a notebook:

1.  In the sidebar, select ![Attach](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/attach.svg) (Attached data) and switch to the Databases tab.

2. Enable the toggle in your database connection.

## Next steps

* To retrieve and process data from the connected database, use [Query data with SQL cells](sql-cells.html) or query them .

* Learn how to manage and delete database connections [in a workspace](databases-as-workspace-resources.html) and [in a notebook](database-connections-on-notebook-level.html).