> ## Documentation Index
> Fetch the complete documentation index at: https://docs.alumio.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MSSQL

> Database connection for Microsoft SQL Server (MSSQL)

Use this to connect Alumio to a Microsoft SQL Server (MSSQL) database. Once it is set up, the connection can be reused by other features that read from or write to your SQL Server database. You can sign in with a username and password, or with a Microsoft Entra service principal (client secret) for Azure-hosted databases. The Advanced tab holds connection tuning and encryption options that you usually do not need to touch.

This documentation describes: [Schema](/schemas/database-connection/mssql-v2)

## Fields

**Server host**

Required

The address of the SQL Server, for example `db.example.com`. This can be a domain name or an IP address.

**Server port**

Optional

The network port the server listens on. If you leave this empty it defaults to `1433`, the standard SQL Server port. Change it only if your server uses a different port.

**Database name**

Required

The name of the database on the server that you want to work with.

**Authentication type**

Optional

How Alumio signs in to the server. Choose **Username and password** for a standard SQL login (the default), or **Microsoft Entra Service Principal (client secret)** for an Azure-hosted database that uses Entra. Your choice decides which credential fields appear below.

**Username**

Optional

The username used to sign in to the database server. Shown when the authentication type is **Username and password**. Leave it empty to connect anonymously.

**Password**

Optional

The password used to sign in. Shown when the authentication type is **Username and password**. You can reference an environment variable here instead of typing the secret directly.

**Client ID**

Required

The identifier for your client application, in the form `00000000-0000-0000-0000-000000000000`. Shown when the authentication type is **Microsoft Entra Service Principal (client secret)**.

**Tenant ID**

Required

The identifier for your Microsoft Entra tenant, in the form `00000000-0000-0000-0000-000000000000`. Shown when the authentication type is **Microsoft Entra Service Principal (client secret)**.

**Client secret**

Required

The secret for your client application. This is only shown once, when you create it in your client application, so copy it then. Shown when the authentication type is **Microsoft Entra Service Principal (client secret)**.

### Advanced

**Connection timeout**

Optional

How many seconds to wait before giving up on a connection attempt. Allowed range is `1` to `60`; defaults to `15`.

**Use encryption**

Optional

Whether to encrypt the connection to the server. Defaults to **Enabled**. Your server may require encryption regardless of this setting.

**Trust server certificate**

Optional

Whether to accept the server's encryption certificate without validating it. Defaults to **Validate certificate**. Choosing **Trust certificate without validation** weakens security, so only use it when you understand the risk.

## Sample data

A typical MSSQL connection using a username and password:

| Field | Value |
| - | - |
| Server host | `your-db-host.example.com` |
| Server port | `1433` |
| Database name | `warehouse` |
| Authentication type | `SqlPassword` |
| Username | `integration_user` |
| Password | `your-password` |

```json theme={null}
{
    "host": "your-db-host.example.com",
    "port": "1433",
    "database": "warehouse",
    "authenticationType": "SqlPassword",
    "username": "integration_user",
    "password": "your-password"
}
```

Connection credentials are shown here as placeholders. For the password you can reference an environment variable instead of typing the secret directly; see [Placeholders](/references/placeholders) for the full syntax.

```json Configuration theme={null}
{
  "prototype": "mssql-v2",
  "parameters": {
    "host": "your-db-host.example.com",
    "port": "1433",
    "database": "warehouse",
    "authenticationType": "SqlPassword",
    "username": "integration_user",
    "password": "your-password"
  }
}
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.