How to Whitelist Your IP - Windows Dedicated

You may need to whitelist your IP address on the server if you want to connect the the server remotely in some situations. For example, whitelisting your IP is necessary for remotely managing databases using software on your computer such as Microsoft Server Management Studio Express.

To whitelist your IP:

  1. Log into RDP (remote desktop).
  2. Go to Start.
  3. Select Administrative Tools.
  4. Click on Windows Firewall With Advanced Security.
  5. Click on Inbound Rules on the left-hand side.
  6. In the middle, click on MSSQL Server or MySQL.
  7. Under the MSSQL Server section, click Properties.
  8. Click the Scope tab.
  9. At the bottom, under Remote IP Address, click Add and add your IP.
  10. Click OK.

Instructions for steps 5 through 10 are illustrated below:

Note: Whitelisting an IP using this method, whitelists it for everything, not just remote SQL access.