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

# Microsoft SQL Server

> Build apps with read and write access to a Microsoft SQL Server database

export const IntegrationSuccess = ({integrationName}) => {
  return <p>
      <b>{integrationName} connected!</b><br />You can now use{" "}
      <a href="/building-with-clark">Clark to build</a> with {integrationName}.
    </p>;
};

export const Alert = ({type, title, children}) => {
  const variant = ["info", "success", "warning", "danger", "note"].includes(type) ? type : "note";
  return <div className={`alert alert--${variant}`}>
      <div className="alert-icon" />
      <div className="alert-content">
        {title && <div className="alert-title">{title}</div>}
        <div className="alert-body">{children}</div>
      </div>
    </div>;
};

## Setting up Microsoft SQL Server

### 1. Add integration

Select **Microsoft SQL Server** from the [integrations page](https://app.superblocks.com/integrations/mssql).

### 2. Configure settings

Fill out the form with the following settings:

| Setting           | Required                                   | Description                                                                         |
| ----------------- | ------------------------------------------ | ----------------------------------------------------------------------------------- |
| Name              | <span className="table-checkmark">✓</span> | Name that will be displayed to users when selecting this integration in Superblocks |
| Host              | <span className="table-checkmark">✓</span> | Hostname or IP address to connect to                                                |
| Port              | <span className="table-checkmark">✓</span> | Port to use when connecting to Microsoft SQL Server                                 |
| Database Name     | <span className="table-checkmark">✓</span> | Name of database to connect to                                                      |
| Database Username | <span className="table-checkmark">✓</span> | Username to use to connect                                                          |
| Database Password | <span className="table-checkmark">✓</span> | Password for database username                                                      |
| Enable SSL        | <span className="table-x">✗</span>         | Connect via SSL if selected                                                         |

### 3. Test and save

Click **Test Connection** to check that Superblocks can connect to the data source.

<Alert type="info">
  If using Superblocks Cloud, add these <a href="/enterprise/security/overview#ip-addresses">Superblocks IPs</a> to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).
</Alert>

After connecting successfully, click **Create** to save the integration.

### 4. Set data tags

Optionally, configure different data tags for [separate development environments](/development-lifecycle/build/data-tags).

<Alert type="success">
  <IntegrationSuccess integrationName="Microsoft SQL Server" />
</Alert>

## Troubleshooting

Check out our guide on [common errors across database integrations](/integrations/troubleshooting/troubleshooting-databases), in addition to [common Microsoft SQL Server connection issues](https://docs.microsoft.com/en-us/troubleshoot/sql/connect/resolve-connectivity-errors-overview). If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at [help@superblocks.com](mailto:help@superblocks.com).