Overview

Some customers may need to access their MSSQL databases remotely for maintenance or bulk operations. This is available for a limited number of Shared Windows based servers and all dedicated Virtual Private Servers (VPS’s).

Note

Access is restricted to Australian and New Zealand based locations only. If you need access outside of this, you will require your own VPS.

Connecting Remotely

Our Windows shared hosting servers allow remote connections to MSSQL via the default port of 1433.

In general you can connect with <Your Domain>,1433 as in our example: yourdomainname.help,1433

If you are using SQL Server Management Studio you can connect with the below, replacing our example domain with your own:

Server TypeDatabase Engine
Server Name <Your Domain Name Here>
AuthenticationSQL Server Authentication
Login<Your Database Username>
Password<Your Database Password>
In the server name field, you can also use the server hostname.
accessing mssql databases remotely

Advice

To prevent issues accessing an MSSQL database remotely, please ensure you’re using an up to date version of the SQL Server Management Studio (SSMS).
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

For .NET applications that access remotely, please update your connection string to replace “.\MSSQLSERVER2019” with <Your Domain Name Here>,1433 per the example below:

Data Source=yourdomainname.help,1433;Initial Catalog=<Your Database Name>; User ID=<Your Database Username>; Password=<Your Database Password>;

Warning

If your connection is timing out connecting, it may be that your service is proxied via a 3rd party such as Cloudflare. In this instance, connecting using your domain name will not work. Please contact the Conetix team for the server name to use in order to connect.

If you have any questions regarding remote connection issues, please contact our support team.

Was this article helpful?

Related Articles