How to Configure IP Restriction on your Private SQL Server

Overview

By default there is no network restriction on the MS SQL port of a Private SQL Server, so it will accept connections from any address. If you want to limit which machines can reach it, you can restrict access to a list of IP addresses you choose.

When the IP Restriction setting is enabled, only the IPs listed in the text box will be allowed to connect to your Private SQL databases. Everything else is refused.

Steps

1. Log in to the Everleap Control Panel at cp.everleap.com.
2. Click the Databases drop down menu in the top navigation.
3. Select Private MS SQL.
4. Click the Edit link next to IP Restriction in the Network Access box.
5. Check Enabled.
6. Enter each IP address that you want to allow to access the server. This tool supports multiple IPs: insert one IP address per line.
7. Click the Save button.

Verify it worked

Connect to the Private SQL Server from a machine whose address is on the list. It should connect as normal. A machine that is not on the list should be refused at the network level, before it gets as far as a login prompt.

Notes

• You do not need to include the IP address of our web servers. We automatically whitelist our own servers, so your sites hosted with us keep working whatever you put in the list.
• Enter one IP address per line. Do not separate them with commas.
• If your office or home connection has a dynamic IP address, it will change from time to time and you will lose access until you update the list. Keep a second route in, or be ready to update it.

Related Articles

• Getting Started with Private SQL Server
• Additional logins for private MS SQL
• Getting Started with MS SQL Server databases