How to Connect to SQL Server Remotely (SQL Server 2012 and Above)

To connect to your SQL Server database remotely using SQL Server Management Studio (SSMS), follow the steps below. These instructions are applicable for SQL Server 2012, 2014, 2016, 2017, 2019, and 2022.

🔧 Remote Connection Settings for SQL Server 2012+

1. Server Name/IP: Use the IP address of your SQL Server along with the port number specified in your control panel’s database settings.

   • Format: xxx.xxx.xxx.xxx,port-number

   • You can obtain these values in your login details email.

2. Authentication Type:

   • Choose SQL Server Authentication.

3. Username:

   • Enter the database user created in your control panel.

4. Password:

   • Use the password associated with your database, as set in the control panel.

✅ Connection Example:

• Server Name: 192.168.1.100,1433 (IP address and port)

• Authentication: SQL Server Authentication

• Username: dbuser

• Password: YourSecurePassword

⚙️ Ensure Remote Connection Settings Are Correct:

Before connecting remotely, verify that the following settings are properly configured:

• Firewall: Ensure that your server’s firewall allows connections on the specified port (default: 1533).

• SQL Server Configuration: Enable TCP/IP connections in SQL Server Configuration Manager.

• SQL Server Services: Make sure that SQL Server is set to allow remote connections under SQL Server Management Studio > Properties > Connections.