# Azure SQL Server

To connect to your SQL Server instance (hosted on Azure Cloud), there are some simple preliminary steps to allow your database to be accessible by our platform.

## Setup

### Firewall

{% hint style="success" %}
Our **IP address** is **35.212.87.86.**
{% endhint %}

You will need to add Erathos IP address to your firewall whitelist. Navigate to the main page of the chosen SQL Server database and select the **Networking** under the **Security** sidemenu. 

Ascertain your database is not completely private by selecting **Selected networks** to allow public access for IPs that comply to the firewall rules. Then, add Erathos platform IP as the **Start IPv4 address** and **End IP address** and give a name easy to identify the rule's purpose at a later time. Persist the new firewall rule by clicking **Save** at the bottom of the page.

<figure><img src="/files/jKoZvw3NkuFuaXEyd3u1" alt=""><figcaption></figcaption></figure>

### Credentials

In order to identify the **host address** of your database and the **username** of the server admin you can navigate to the **Overview** sidemenu option of the main page of the selected database, where you can find the credentials under the **Essentials** section.

<figure><img src="/files/sd9uU6kh4ENKi1Fo8FJm" alt=""><figcaption></figcaption></figure>

It is also possible to locate your **host address**, **database port**, **database name** and **admin** **username** by navigating to **Azure SQL Database > SQL databases** and selecting the database you wish to use as your target data warehouse. Inside the database, select **Settings > Connection strings** in the sidemenu to view your credentials. &#x20;

<figure><img src="/files/LEpuBelDeGxZipwt9zxT" alt=""><figcaption></figcaption></figure>

## Connect to Erathos

To connect Erathos to your Azure SQL Server:

1. **Create a New Destination**
   * Go to **Settings** > **Data Warehouse**.
   * Select **Azure SQL Server**.
2. **Fill Out the Form**

   * Input your credentials, such as **Host address**, **Database name**, **Server admin** **password Database port** and **Server admin username**.

   <figure><img src="/files/rjWgISY3lZnw1iVL0jQk" alt=""><figcaption></figcaption></figure>
3. **Advanced Connection Settings (Optional)**
   * If you wish to establish your connection through your own server in order to restrict the direct access to the database you may also fill out the ssh credentials form. For more information, please referer to [Databases connection types](/connectors/databases.md#connection-types).

{% hint style="info" %}
If you need help connecting to your SQL Server, reach out to our team at <support@erathos.com>.
{% endhint %}


---

# Agent Instructions: 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:

```
GET https://docs.erathos.com/destinations/azure-sql-server.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.