How can I access a sql server that is inside a subnet?

Question

How can I access a sql server that is inside a subnet?
There is a main router with a public IP, then there is another router where my network is. I can't configure the main router to publicly access the server.
What options do you recommend? I am new to Azure and would like suggestions on what I can do. I know that the VPn is an option, but it is only for the sql service.
Edit: I haven't implemented anything in Azure yet, everything happens in my local network but I want to access the sql service from the outside.

Answer 1

Hi CristopherSalazar-4978,

Welcome to Microsoft Q&A.
Are there any error message when connecting to SQL Server?
Please make sure TCP/IP is enabled in the SQL Server configuration Manager.
And check the firewall to allow authorized users or computers to access the ports on which sql server listens. If the SQL Server is named instance with dynamic port, please ensure the SQL Server browser is enabled, and add a firewall rule to allow traffic from the client to the SQL Server machine on UDP port 1434. Please check https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15 and https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15 which might be helpful.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.