1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Whitelisting IP Address - Windows Dedicated

Whitelisting IP Address - Windows Dedicated

You may need to whitelist your IP address on the server if you want to connect to 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:

Note: If you don't see MSSQL Server or MySQL Server options under Inbound Rules, install the Software first. You can also contact us via phone or Live Chat; however, a ticket will be raised to a WinAdmin for installation.
  1. Log into RDP (Remote Desktop).
  2. Go to Start.
  3. Select Administrative Tools.
  4. Click on Windows Firewall With Advanced Security.

    Windows Firewall with Advanced Security

  5. Click on Inbound Rules on the left-hand side.

    Inbound Rules

  6. In the middle, double-click on MSSQL Server or MySQL Server.

    MSSQL Server and MySQL Server

  7. Click the Scope tab.

    MSSQL Server Properties Scope Tab

  8. At the bottom, under Remote IP Address, click Add and add your IP.
  9. Click OK.
Note: Whitelisting an IP using this method would whitelist for remote SQL access.