# SQL Server

## Creating a connection

To connect to SQL Server, you'll need to provide the below details:

{% hint style="info" %}
Fill in following details in the form. We use Azure SQL service as an example here:
{% endhint %}

1. **Server**: The server name. It can be found in Azure Portal: *SQL Server -> Server Name -> Overview -> Server Name*
2. **Database**: The database name. This can be found in the Azure Portal at the following location: *SQL Server -> Server Name -> Overview -> Available Resources -> (x) databases*.
3. **Database or Schema**: The schema to connect to
4. **User**: The username
5. **Password** : The password

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

{% hint style="info" %}
Note:

* The User and Password above are for the SQL Authentication.
* In order to connect to a privately hosted instance, the customer will need to whitelist the IPs from Telmai. Please reach out to Telmai support for the updated list of IP’s for whitelisting.
  {% endhint %}

## Connecting an asset

Once a connection is defined, you can start using it to create assets. To create assets, you will need to select existing table, or run a custom SQL query.

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

{% hint style="warning" %}
JSON data type is not supported for SQL Server connections out of the box. Please reach out to Telmai support if it needs to be enabled
{% endhint %}

{% hint style="info" %}
Please ensure that your environment has whitelisted [Telmai IP list](/telmai/api-reference/telmai-ip-list.md).
{% 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.telm.ai/telmai/connect-to-data/data-connections/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.