> For the complete documentation index, see [llms.txt](https://docs.ledge.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ledge.co/integration-guides/databases-and-data-warehouses/how-to-guide-locating-the-required-details-to-connect-microsoft-sql-server.md).

# How-to Guide: Locating The Required Details to Connect Microsoft SQL Server

## Microsoft SQL Server Integration Guide

This guide will help you set up integrations with your **Microsoft SQL Server** database, including locating important details and allowing access from Ledge's static IP address.

> **Note:** You will need admin privileges to complete this guide. Your database administrator should have the details available and can help in setting up permissions.

For convenience, below are instructions on getting the required details based on your cloud provider:

* Azure
* Google Cloud Platform (GCP)
* AWS

***

### Azure

#### Step 1: Locate Your SQL Server URL and Port

1. Sign in to the **Azure Portal**.
2. Navigate to **Azure SQL Database** or **SQL Server** by searching for "SQL Server" in the search bar.
3. Select your SQL Server or SQL Database from the list.
4. Under the **Overview** tab, find the **Server name**. It looks something like:

   ```
   your-server-name.database.windows.net
   ```
5. The port for SQL Server is usually `1433`.
6. On Ledge, copy & paste the host & port into the appropriate fields.

#### Step 2: Locate Your Schema and Tables

1. Open a SQL Server client like **SQL Server Management Studio (SSMS)** or **Azure Data Studio**.
2. Connect to your SQL Server using the server name, port, username, and password.
3. Once connected, expand the database in the left-hand menu to view schemas and tables.
   * **Schema:** Groups tables and other objects in your database.
   * **Tables:** Data is stored in tables, typically listed under each schema.
4. On Ledge, copy & paste the Schema & tables into the appropriate fields.

#### Step 3: Add Ledge IP Address to the Allow List

1. In the **Azure Portal**, go to your SQL Server.
2. Under **Settings**, select **Networking** or **Firewalls and virtual networks**.
3. Add a new firewall rule:
   * **Rule name:** `Allow-34.231.208.110`
   * **Start IP:** `34.231.208.110`
   * **End IP:** `34.231.208.110`
4. Save the changes.

***

### Google Cloud Platform (GCP)

#### Step 1: Locate Your SQL Server URL and Port

1. Sign in to the **Google Cloud Console**.
2. Navigate to **Cloud SQL** by searching for "Cloud SQL" in the search bar.
3. Select your SQL Server instance from the list.
4. In the **Instance Details**, locate the **Public IP address** under the *Connect to this instance* section.
   * Example: `192.168.13.37`
5. The port for SQL Server is usually `1433`.
6. On Ledge, copy & paste the host & port into the appropriate fields.

#### Step 2: Locate Your Schema and Tables

1. Open a SQL Server client like **SQL Server Management Studio (SSMS)** or **Azure Data Studio**.
2. Connect to your SQL Server instance using the public IP address, port, username, and password.
3. Once connected, view schemas and tables by expanding the database objects in your client.
4. On Ledge, copy & paste the Schema & tables into the appropriate fields.

#### Step 3: Add Ledge IP Address to the Allow List

1. In the **Google Cloud Console**, go to your SQL Server instance.
2. Under the **Connections** tab, find the **Authorized networks** section.
3. Add a new network:
   * **Name:** `Allow-34.231.208.110`
   * **Network:** `34.231.208.110/32`
4. Save the changes.

***

### AWS

#### Step 1: Locate Your SQL Server URL and Port

1. Sign in to the **AWS Management Console**.
2. Navigate to **RDS (Relational Database Service)**.
3. Select your SQL Server instance from the list.
4. Under **Connectivity & security**, find the **Endpoint**. It looks something like:

   ```
   your-instance-name.abc123xyz.region.rds.amazonaws.com
   ```
5. The port for SQL Server is usually `1433`.
6. On Ledge, copy & paste the host & port into the appropriate fields.

#### Step 2: Locate Your Schema and Tables

1. Open a SQL Server client like **SQL Server Management Studio (SSMS)** or connect using an EC2 instance.
2. Connect to your SQL Server instance using the endpoint, port, username, and password.
3. Once connected, explore the database to view schemas and tables.
4. On Ledge, copy & paste the Schema & tables into the appropriate fields.

#### Step 3: Add Ledge IP Address to the Allow List

1. In the **AWS Management Console**, navigate to **RDS**.
2. Under **Connectivity & security**, find the **VPC security groups** section.
3. Click on the security group associated with your database.
4. In the **Security Groups** page, go to the **Inbound rules** tab.
5. Add a new rule:
   * **Type:** `Microsoft SQL Server`
   * **Protocol:** `TCP`
   * **Port Range:** `1433`
   * **Source:** `34.231.208.110/32`
6. Save the changes.

***

### Final Steps

With these steps completed, your **Microsoft SQL Server integration** is set up, and the IP address `34.231.208.110` has access.

If you need further help, reach out to your Ledge CSM or contact your IT support team.