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

# Microsoft SQL Server

<Card title="Strong Security" icon="shield-check" iconType="sharp-solid" color="#49DE80">
  Brewit never has access to your database credentials. All credentials are
  encrypted and stored in AWS Secret Manager.
</Card>

## Connect your Microsoft SQL Server

<Steps>
  <Step title="Create">
    Create Microsoft SQL Server connection
    [here](https://app.brewit.ai/resources/new/microsoft_sql_server)
  </Step>

  <Step title="Configure">
    Information needed: Host, Port, Database Name, Username, Password
  </Step>

  <Step title="Test the connection">
    Click **Test Connection** button to verify that Brewit can successfully
    connect to Microsoft SQL Server. If the test fails, check the data source
    settings and try again.
  </Step>

  <Step title="Save the resource">
    Click **Create** button to complete the setup. Now you can start chatting
    with Brewit's BI agent to analyze your data.
  </Step>
</Steps>

## Whitelist Brewit's IP addresses

If the data source is behind a firewall or restricts access based on IP address, then you must ensure that Brewit can access it.
If necessary, configure your data source to allow access from Brewit's IP addresses.

Allow Brewit to read into your Microsoft SQL Server using the following IP addresses:

```
18.235.135.168
34.194.74.33
```