How to allow IP address in Windows Dedicated Server for Remote Access?

You can able to allow the MSSQL access for the particular IP address in firewall from the remote desktop servers using software [Example : SQL Management Studio]. It will useful to avoid the unwanted access from the other ip addresses. So that you can able to secure the database from the attackers. This is very important security settings for database servers. SiliconHouse Provides the cheapest price in Windows Dedicated Server.

Kindly follow the below procedure to allow the ip address in Windows Dedicated Server :

1] In your local system click on Windows start button

2] In search type Remote Desktop Connection

3] Give Your Server IP

4] Enter the username and password which you got in your welcome mail

5] Click on connect

6] If you are getting any certificate warning you can click on Yes and proceed.

7] Now you can able to login into your Windows Dedicated Server

8] In search type Windows Security with Advanced on Local computer

9] Click Inbound Rules

10] You can create the new rule and allow set the MSSQL access for particular IP address

11] Click the Rule which you have created

12] Click Scope

13] Add your network IP address under Remote IP address

14] Click Add

15] Click Ok

Now you have successfully added the IP  address in firewall. You can able to connect the remote database by using SQL Management Studio.