Unable to access SQL server from public network

Question

We have setup a SQL server within our windows virtual machine. However, it is not accessible from the public network.

We have opened the TCP ports 1433 and 1434 by creating the firewall rule
RDP is accessible. And we are able to use the SQL Management studio from within the VM but not from the public network.

Are we missing any configuration?

Any help would be much appreciated.
Thanks in advance

Answer 1

Here is a troubleshooter you can use: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017

Answer 2

Hi @Pradeep Sahoo ,

Please refer to this: https://learn.microsoft.com/en-us/troubleshoot/sql/connect/resolving-connectivity-errors, which can handle regular connection issues.
This blog is about Making SQL Server Accessible Over Internet. Among these steps, have you completed the fourth step?
And if your server is SQL Server Express - make sure it is configured to accept remote connections (this is disabled by default in SQL Express, it listens local connections only).
See here for example how to enable SQL Express to accept remote connections.
Could you provide the error message which will be helpful for solving the problem?

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Thank you @Erland Sommarskog for your prompt help.
It worked! The firewall configuration had to be modified to allow port 1433. Unfortunately this rule was setup incorrectly earlier.

Thank you @Seeya Xi-MSFT for your input as well.