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.