Skip to main content
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.

​
Fields

​
Advanced

​
Sample data

A typical MSSQL connection using a username and password:
FieldValue
Server hostyour-db-host.example.com
Server port1433
Database namewarehouse
Authentication typeSqlPassword
Usernameintegration_user
Passwordyour-password
{
    "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 for the full syntax.