Connecting an Azure SQL Database Destination to Stitch

Last updated: 9/15/2026

Prerequisites

• An up-and-running Azure SQL Database instance. Instructions for creating a Azure SQL Database destination are outside the scope of this tutorial; our instructions assume that you have an instance up and running. For help getting started with Azure SQL Database, refer to Microsoft’s documentation.

Step 1: Verify your Stitch account's data pipeline region

First, you’ll log into Stitch and verify the data pipeline region your account is using. Later in this guide, you’ll need to grant Stitch access by whitelisting our IP addresses.

The IP addresses you’ll whitelist depend on the Data pipeline region your account is in.

1. Sign into your Stitch account, if you haven’t already.
2. Click User menu (your icon) > Edit User Settings and locate the Data pipeline region section to verify your account’s region.

3. Locate the list of IP addresses for your region:

   • North America region IP addresses

   • Europe region IP addresses

Keep this list handy - you’ll need it later.

Step 2: Configure database connection settings

In this step, you’ll configure the database server to allow traffic from Stitch to access it. There are two ways to connect your database:

• A direct connection will work if your database is publicly accessible.
• An SSH tunnel is required if your database isn’t publicly accessible. This method uses a publicly accessible instance, or an SSH server, to act as an intermediary between Stitch and your database. The SSH server will forward traffic from Stitch through an encrypted tunnel to the private database.

Click the option you’re using below and follow the instructions.

I'm using an SSH tunnel to connect.

1. Follow the steps in the Setting up an SSH Tunnel for a Microsoft Azure database guide to set up an SSH tunnel for Azure SQL Database.
2. Complete the steps in this guide after the SSH setup is complete.

I'm using a direct connection.

For the connection from Stitch to be successful, you’ll need to configure the firewall for your Azure SQL Database instance to allow access from our IP addresses.

1. Sign into your Azure SQL Database account and navigate to your dashboard.

2. In the sidenav, click SQL databases.
3. On the page that displays, click the name of the database you want to connect to Stitch.
4. The details page for the database will display. Click the link in the Server name field.

5. The details page for the server will display. Click the Show firewall settings link in the Firewalls and virtual networks field.

6. For each of the IP addresses you retrieved in Step 1 for your Stitch data pipeline region, create a rule:
   • Rule name: Enter a name for the rule. For example: Stitch<number>
   • Start IP: Paste one of the Stitch data pipeline region IP addresses.
   • End IP: Paste the same IP address.
7. Click the three dots to the right of the End IP field to add the rule.

8. Repeat steps 6 and 7 until there is a rule for each IP address for your Stitch data pipeline region. Below is an example of what this might look like using Stitch’s North America IP addresses:

   

   Note: You may also want to add your own IP address(es) to this list. This ensures that you’ll also be able to connect to the database as needed.

9. Click Save.

Step 3: Create a Stitch Azure SQL Database database user

In the following tabs are the instructions for creating a Stitch Azure SQL Database database user and explanations for the permissions Stitch requires.

• Instructions
• Privileges list

Step 4: Connect Stitch

To complete the setup, you need to enter your Azure SQL Database connection details into the Destination Settings page in Stitch.

Step 4.1: Enter connection details into Stitch

1. If you aren’t signed into your Stitch account, sign in now.

2. Click the Destination tab.

3. Locate and click the Azure SQL Database icon.
4. Fill in the fields as follows:

Step 4.2: Define SSH connection details

If you’re using an SSH tunnel to connect your Azure SQL Database database to Stitch, you’ll also need to define the SSH settings. Refer to the Setting up an SSH Tunnel for a Microsoft Azure database guide for assistance with completing these fields.

1. Click the Encryption Type menu.

2. Select SSH to display the SSH fields.

3. Fill in the fields as follows:

   • Remote Address: Enter the public IP address or hostname of the server Stitch will SSH into.

   • SSH Port: Enter the SSH port on your server. (22 by default)

   • SSH User: Enter the Stitch Linux (SSH) user’s username.

Step 4.3: Define SSL connection details

Check the Connect using SSL checkbox. Note: The database must support and allow SSL connections for this setting to work correctly.

Step 4.4: Save the destination

When finished, click Check and Save.

Stitch will perform a connection test to the Azure SQL Database database; if successful, a Success! message will display at the top of the screen. Note: This test may take a few minutes to complete.