Silicon House is a complete solution provider for reseller hosting, dedicated servers and cloud servers. Our expertise is in implementing high availability, high performance and hybrid cloud servers / dedicated servers. Silicon House runs hundreds of servers serving customers in more than 90+ countries. Our commitment towards quality is shown in our processes and products that we deliver to thousands of customers around the world. 

Instructions:
==   
If you want to connect the database via sql management studio, you need to add your static IP (can be bought from your ISP provider) or dynamic IP by visiting the URL getmyip.co.in

Please note that you can add ips instantly to access your database remotely through the “AddSQLIP” option in the plesk panel. To add ip addresses, follow the steps given below;
Login to your plesk control panel

Click on the domain name you wish to add the ip for sql access from the subscriptions list

Click on Websites and Domains option in your control panel

Click on AddSQLIP button in the control panel

Supply the IP Address and submit

Wait for 15-20 min to get your ip reflected in the firewall

NOTE:

The IP addition is strictly for MS SQL Studio access only. Such an IP addition should be done occasionally for tweaking your tables etc. It should not be used on a regular basis. To check your current local internet ip, visit www.whatismyip.com

If you wish to take backup on a regular basis, please go for Arrow SQL Arc. SQL Database Management for your windows account is easier now with “Arrow SQLArc”.

Arrow SQLArc, state of the art sql db backup management tool which allows you to dump backup of your sql databases in your website. By enabling this, you will be able to dump weekly backup of your MSSQL automatically under the ftp of each website in your domain. This backup can be downloaded easily through ftp.
Only one IP address can be added in a domain at a time. You can add only 5 times max in a day

Remote access to SQL Server is purely for MS SQL Studio only. Please DO NOT USE it for remote access via your application. If found to abuse this, the account and db will be permanently disabled.

IP added here will take upto 15 mins to reflect in the firewall.

Then you can access the database via sql management studio.

Note : If it is a dynamic IP, the database connection will be disconnected if you switch off your modem or system and the ip will be flushed from the firewall after 12 hrs.For permanent solution, You can get the static IP.

After whitelisting the IP address, you can able to connect the database by using below mentioned connection steps:

Mssql connection steps using management studio: 

Server type : Database engine
Server name : server IP
Authentication : SQL server authentication
Login : database username
Password : database password