Description :
This procedure allows you to access the SQL Management Studio.
Required Information :
* Your website's hosting control panel user name and password
* Database username and password
* Your system ip address
Procedure :
You can connect the database via sql management studio, using the below procedure
To access the database your ip should be allowed in firewall by visiting the url [ http://getmyip.co.in./ ]
You can add ips instantly to access your database remotely through "AddSQLIP" option in the plesk panel. To add ip addresses, follow the steps given below;
[1] Login to your plesk control panel
[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list
[3] Click on Websites and Domains option in your control panel
[4] Click on AddSQLIP button in the control panel
[5] Supply the IP Address and submit
[6] Wait for 15-20 min to get your ip reflected in the firewall
NOTE:
[1] 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 http://getmyip.co.in.
[2] 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 thro ftp.
[3] Only one IP address can be added in a domain at a time. You can add only 5 times max in a day
[4] 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.
[5] 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
 |
 |
 |
