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

Cristopher Salazar 1 Reputation point
2022-04-12T04:42:13.257+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,113 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-04-12T07:04:19.867+00:00

    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.

    0 comments No comments