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

# ETL: Connecting to Microsoft SQL Server

> Connect Microsoft SQL Server to Integrate.io ETL for reading and writing data. Configure firewall rules, credentials, and connection settings.

* Create a user and grant it minimum permissions required for Integrate.io ETL to read or write data from the database.
* Allow access from [Integrate.io ETL's IP addresses](/etl/integrateio-etls-ip-list/) to your SQL Server database port (Refer to [this](/etl/allowing-integrateio-etl-access-to-my-server-behind-a-firewall/) article if you'd prefer to create an SSH tunnel or reverse SSH tunnel.) Note: We only support **"Default"** [connection policy](https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql\&tabs=azure-portal#change-the-connection-policy) on Azure SQL/Synapse Analytics.

<Frame>
  <iframe className="w-full aspect-video rounded-xl" src="https://fast.wistia.com/embed/iframe/ln8o4j27j5" title="Allowing Integrate.io ETL access to Microsoft SQL Server Databases" allow="autoplay; fullscreen" allowFullScreen />
</Frame>

## To create a Microsoft SQL Server database connection in Integrate.io ETL

<Steps>
  <Step>
    Click the **Connections** icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    To create a connection, click **New connection**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-33.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=5ceb9a7be418162b90bd3309360d14c3" alt="New connection button in the Connections page" width="1200" height="830" data-path="images/connectivity-and-security/image-33.webp" />
    </Frame>
  </Step>

  <Step>
    Select SQL Server and name the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-34.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=bd3778b9e1aeccbf9999ef54f2088e0c" alt="Selecting SQL Server as the connection type" width="1200" height="830" data-path="images/connectivity-and-security/image-34.webp" />
    </Frame>
  </Step>

  <Step>
    Select your access type (direct connection if you've whitelisted Integrate.io ETL's IP addresses.)
  </Step>

  <Step>
    Enter your SQL Server database server name as the hostname.
  </Step>

  <Step>
    Enter the database name.
  </Step>

  <Step>
    Enter the user name. Use the pattern **user\@server\_name** as the user name.
  </Step>

  <Step>
    Enter the user's password.
  </Step>

  <Step>
    Click **Test Connection** to make sure the connection details are correct.
  </Step>

  <Step>
    Click **Create connection** to create the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-35.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=48e1d6890e7f21f7643d3d2a137b2a8c" alt="SQL Server connection configuration form with host, database, and credentials" width="1200" height="830" data-path="images/connectivity-and-security/image-35.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-36.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=f096c11e196ccc1e221b3686a5c97591" alt="Successful SQL Server connection test confirmation" width="1200" height="830" data-path="images/connectivity-and-security/image-36.webp" />
    </Frame>
  </Step>
</Steps>