> For the complete documentation index, see [llms.txt](https://docs.telm.ai/telmai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.telm.ai/telmai/connect-to-data/data-connections/sql-server.md).

# 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 %}