To manage your MS-SQL databases remotely using SQL Server Management Studio (SSMS), your server must be configured to allow inbound traffic on the standard SQL Server port (1433).
⚠️ Important Security Guidelines
-
Shared Hosting Users: If you are on a shared Plesk server, this port is already open. You do not need to follow these steps.
-
Static IP Recommendation: For maximum security, we strongly recommend only opening the port for your specific Static IP address.
-
Public Access Warning: Opening port 1433 to "All" (0.0.0.0/0) is highly discouraged. Doing so exposes your database to constant automated brute-force attacks.
-
IPBan Pro: If you must allow public access, it is essential to use the IPBan Pro add-on. This tool automatically detects and blocks malicious login attempts, preventing your server resources from being overwhelmed by hackers.
Steps to Open the SQL Port in Plesk Firewall
If you are using a VPS with the Plesk Firewall enabled, follow these steps to allow remote connections:
1. Access the Firewall Settings
Log in to your Plesk control panel and navigate to Tools & Settings. Under the Security section, click on Firewall.
2. Enable Firewall Management
If the firewall is not already active, click to Enable. If it is already running, click Firewall Rules.
3. Update the Firewall rule
Look for the MS SQL over TCP protocol rule and click on it.
4. Configure the Rule Parameters
Ensure the checkbox Turn on the rule is ticked.
In the Remote addresses textbox, enter your static IP address.
Use the Add one more link to add additional IP addresses.
6. Apply Changes
-
Click OK to save the rule.
-
You will be returned to the main Firewall page. Click the Apply Changes button at the top to push the new configuration live.
You should now be able to connect via SSMS using your server's IP address and your database credentials.
Please see this article for instructions on creating an SSMS connection to your database:
Connecting to SQL Server using Microsoft SQL Server Management Studio
