HOW TO CONNECT TO MS SQL REMOTELY?

How to Access Microsoft SQL Server 2008 R2 Remotely

In order to manage your Microsoft SQL databases, you will first  need download and install Microsoft SQL Management Studio. Once you have it installed, your IP address will need to be whitelisted so that you can access MS SQL remotely.

When opening MS SQL Management Studio, you will see a login screen which requires the following details:

  • Server Type - Select Database Engine.
  • Server Name - You can use any address which resolves to your server, including:
    • Your account's IP address
    • Server hostname (e.g. PSS20.win.hostgator.com)
    • Your domain name (must be pointed to our server)
  • Authentication - Windows Authentication can only be used by Dedicated Server owners. This option is for if you are logging in remotely without using SQL Server Authentication or if you are connecting with Remote Desktop.
  • Login - This will be your database username which can be found in the Websites & Domains section Plesk Panel by selecting the databases icon and then selecting the database you wish to use.
  • Password: This will be your database user password.

    Server Connect

Common Issues When Logging In

The following is a common error message which may occur when you attempt to log into MS SQL Server remotely:

IP Connection Failed

There are several possible solutions to this error listed below. If you are still receiving an error message after eliminating these possibilities, please submit a ticket for assistance.

Whitelist IP Address

Whitelisting your IP address permits connections to the database server from your current internet connection. Once you have whitelisted your IP address, it can take up to one hour for whitelist modifications to take effect. Users with a dynamic IP address will be required to whitelist again if the IP address changes. Please open a support Ticket for us to whitelist your IP address.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to download mail using an e-mail program - Windows

To set up Microsoft Outlook Express: Open Microsoft Outlook Express. Go to Tools >...

How to download mail using an e-mail program - Windows

To set up Microsoft Outlook Express: Open Microsoft Outlook Express. Go to Tools >...

How to change SMTP port number - Windows

To set up Microsoft Outlook Express: Open Microsoft Outlook Express Go to Tools >...

How to setup a subdomain - Windows

To set up a subdomain: Click Subdomains on your home page. Click Add New Subdomain....

Can't send mail but can receive - Windows

Usually when a user cannot send mail it is caused by a block on the Internet service provider's...