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

# Microsoft SQL Server

> Connect Microsoft SQL Server to Paradime to run dbt™ against your SQL Server or Azure SQL database from the Code IDE, Bolt, and Agent.

[Microsoft SQL Server](https://www.microsoft.com/en-us/sql-server) is a relational database management system developed by Microsoft. Connect it to Paradime to develop dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent run dbt™ models and queries during background sessions.

<Warning>
  **IP restrictions**

  Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

  See also: [Paradime IP addresses](/developers/ip-restrictions).
</Warning>

<Note>
  **Available in:** Code IDE, Bolt, and Agent environments.
</Note>

## Add a connection

1. Click **Settings** in the top menu bar of the Paradime interface to access **Workspace Settings**.
2. In the left sidebar, click **Environments**.
3. Click **Add New** next to the section for the environment you are configuring:
   * **Code IDE** for the Code IDE connection
   * **Bolt** for the Bolt connection
   * **Agent** for the Agent connection
4. Select **Microsoft SQL Server**.
5. In the **Profile Configuration** field, add at least the required parameters. For additional options, see the [Profile fields reference](#profile-fields-reference).
6. Provide a dbt™ **Profile Name** (this should match the profile name set in your `dbt_project.yml`).
7. In the **Target** field, enter the target for the environment you are configuring: `dev` for Code IDE, `prod` for Bolt, or `dinoai` for the Agent.
8. The **Schema** field is pre-configured, but you can change it to specify the schema where dbt™ builds objects.
9. The **Threads** value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

## Profile configuration

Add at least these required parameters:

```yaml theme={"system"}
driver: 'ODBC Driver 18 for SQL Server'     # ODBC Driver 18 for SQL Server
server: sql.company.com                     # Hostname or IP address
port: 1433                                  # Default: 1433
database: analytics_db                      # Name of the database
user: sql_user                              # SQL Server username
password: your_password                     # SQL Server password
```

<Info>
  After adding the configuration, ensure it is properly formatted using a YAML formatter like [YAML Formatter](https://jsonformatter.org/yaml-formatter).
</Info>

## Profile fields reference

| Field                 | Description                                              | Example                         | Default Value                   | Required |
| --------------------- | -------------------------------------------------------- | ------------------------------- | ------------------------------- | -------- |
| driver                | ODBC driver                                              | `ODBC Driver 18 for SQL Server` | `ODBC Driver 18 for SQL Server` | ✅        |
| server                | Server hostname or IP                                    | `sql.company.com`               | None                            | ✅        |
| port                  | Server port number                                       | `1433`                          | `1433`                          | ✅        |
| database              | Database name                                            | `analytics_db`                  | None                            | ✅        |
| schema                | Schema name. This is configured in the UI "Schema" field | `dbo`                           | None                            | ✅        |
| user                  | Authentication username                                  | `sql_user`                      | None                            | ✅        |
| password              | Authentication password                                  | `your_password`                 | None                            | ✅        |
| retries               | Number of query retry attempts                           | `3`                             | `1`                             | ❌        |
| encrypt               | Enable connection encryption                             | `true`                          | `true`                          | ❌        |
| trust\_cert           | Trust server certificate                                 | `false`                         | `false`                         | ❌        |
| login\_timeout        | Connection timeout in seconds                            | `10`                            | `0`                             | ❌        |
| query\_timeout        | Query timeout in seconds                                 | `300`                           | `0`                             | ❌        |
| schema\_authorization | Schema owner principal                                   | `db_owner`                      | None                            | ❌        |

## Related

<CardGroup cols={2}>
  <Card title="Optional connection attributes" href="/guides/data-warehouse-essentials/optional-connection-attributes" icon="gear" horizontal>
    Set additional `profiles.yml` attributes for this connection.
  </Card>
</CardGroup>


## Related topics

- [SQL Server Tools](/products/dino-ai/tools-and-features/warehouse-tool/sql-server-tools.md)
- [Bolt environment](/products/settings/connections/scheduler-environment/index.md)
- [Agent environment](/products/settings/connections/dinoai-background-agent-environment/index.md)
- [Code IDE environment](/products/settings/connections/development-environment/index.md)
- [Microsoft Fabric](/integrations/microsoft-fabric.md)