---
title: Create an Azure SQL Data Source in Jet Reports
description: "## **Overview: Connecting Azure SQL to Jet Reports**   To utilize Jet Reports for accessing your Azure SQL Database, you first need to create a Universal Data Source connection. This allows [Jet Reports](https://globaldata365.com/jet-reports/) to fetch data directly from your Azure-hosted…"
url: "https://globaldata365.com/helpcenter/create-an-azure-sql-data-source-in-jet-reports/"
updated: "2026-07-01"
category: Jet Reports
---

# Create an Azure SQL Data Source in Jet Reports

## **Overview: Connecting Azure SQL to Jet Reports**

 

To utilize Jet Reports for accessing your Azure SQL Database, you first need to create a Universal Data Source connection. This allows [Jet Reports](https://globaldata365.com/jet-reports/) to fetch data directly from your Azure-hosted database for dynamic reporting.

 

Before you begin, ensure you’ve:

 

- [Installed the latest version of Jet Reports](https://globaldata365.com/helpcenter/how-to-install-jet-reports-excel-add-in/) from the insightsoftware download site.
- Collected the following prerequisites:

  - **Jet License Activation Code**
  - **Azure SQL Database Details**:

    - Server Name
    - Database Username and Password

 

### **Step-by-Step: Create an Azure SQL Data Source in Jet Reports**

 

#### **1. Open Data Source Settings in Jet Reports**

- Launch Excel and go to the **Jet ribbon**.
- Select **Settings > Data Source Settings**. ![data source in jet reports](https://globaldata365.com/wp-content/uploads/2025/07/1-2-300x105.webp)

#### **2. Add a New Data Source**

- In the Data Source Settings window, click **Add**. ![add data source in jet reports](https://globaldata365.com/wp-content/uploads/2025/07/2-2-300x75.webp)
- In the New Data Source window:

  - Name your data source (e.g., “AzureSQL_Production”).
  - For **Type**, select **Other (Universal)**.
  - Click **OK**. ![Azure SQL Data Source in Jet Reports](https://globaldata365.com/wp-content/uploads/2025/07/3-2-300x283.webp)

#### **3. Configure the Data Source**

- Back in the Data Source Settings window, click **Configure…**.
- The **Data Link Properties** window will open. ![Azure SQL Data Source in Jet Reports](https://globaldata365.com/wp-content/uploads/2025/07/5-1-300x249.webp)

#### **4. Choose the Correct Provider**

- On the **Provider** tab, choose **SQL Server Native Client 11.0**.

  > ⚠️ *If this option is not available, download it from Microsoft:*

  - [32-bit Version](http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409)
  - [64-bit Version](http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409)

Using older providers may reduce functionality, so using **SQL Server Native Client 11.0** is recommended for Azure SQL compatibility.

 

#### **5. Set Connection Details**

On the **Connection** tab:

- **Server Name**:
  `your_server_name.database.windows.net`
- **User Name**:
  `your_username@your_server_name`
- **Password**:
  Enter your database password and **check "Allow saving password"**. ![Azure SQL Data Source in Jet Reports](https://globaldata365.com/wp-content/uploads/2025/07/6-1-239x300.webp)

If the password doesn't save, go to the **All** tab and set:

- `Persist Security Info = True`

#### **6. Test the Connection**

- Click the **Test Connection** button.
- A success message ("Test Connection Succeeded") should appear. ![](https://globaldata365.com/wp-content/uploads/2025/07/7.png)

Click **OK** to confirm and return to the Data Source Settings window.

 **Looking to simplify financial reporting in Excel?** [👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training-austin-tx/) and learn to create real-time, dynamic reports with confidence.

### **Licensing and Defaults**

 

- If you see **"You are not licensed for this data source"**, click the message to troubleshoot using license information.
- To make this Azure SQL Data Source your default for Jet Reports, click **Set Default**.
- Click **OK** to finalize.

 

### **Your Azure SQL Data Source is Ready!**

 

You’ve now successfully created an Azure SQL Data Source in Jet Reports. You can begin building real-time, dynamic reports using your Azure-hosted data directly in Excel.

 

#### **Why Use Azure SQL with Jet Reports?**

 

- **Cloud-Powered Reporting** – Access real-time data from anywhere.
- **Secure Connection** – Rely on Azure’s enterprise-grade security.
- **High Performance** – Optimize large data sets for fast analysis.

 

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!