1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Remotely Accessing Microsoft SQL Server

Remotely Accessing Microsoft SQL Server

To manage your Microsoft SQL databases, you will first need to download and install Microsoft SQL Management Studio

When opening MS SQL Management Studio, you will see a login screen that 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., hgws20.win.hostgator.com)
    • Your domain name (must be pointed to our server)
  • Authentication -Dedicated Server owners can only use Windows Authentication. 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 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 contact us via phone or Live Chat for assistance.

Change Password

The password you're using to log in may be incorrect. To resolve this issue, change the database password to something easier to remember.

Please note: This method may break scripts utilizing the previous password setting, and affected applications will need their configuration updated accordingly.

Check Local Firewall/Security Settings

Check your router, firewall, and antivirus that all have the potential to block access to this port. Please contact the manufacturer of these devices for modification procedures.