Share via

Unable to access Azure SQL database from Windows server

Stephen Roberts 0 Reputation points
Dec 11, 2023, 2:16 PM

I have created a new Azure SQL database which I am able to access from my local development machine using SQL Management Studio after I added my client IP to the firewall rules. We have a Windows server that also needs access to this new database, but even though I have added the server's IP address to the firewall rules in Azure the connection is failing when I try to connect from the Windows server using Management Studio.

I have checked that port 1433 is open (both incoming and outgoing) on the Windows server, but the connection is still failing. Is there something else that needs updating to allow the server to reach the SQL instance in Azure?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,517 Reputation points Microsoft Employee
    Dec 27, 2023, 6:56 PM

    @Stephen Roberts  The error message saying that client machine is not reaching to the UK South region Gateway IP address (51.105.64.0).

    Next Steps: you need to work with your internal networking team to allow this Gateway IP address from your client machine firewall. in this scenario,

    1. Azure SQL Server database is created in the UK South region.
    2. if we want to connect to any region database make sure that respective region Gateway IP address need to be allowed from the client machine firewall.
    3. This is a client side networking issue and For testing purposes, you can try connecting to the database from a laptop machine that is not attached to any VPN. This will help you determine if the issue is related to your client machine's firewall settings.

    For more information on Azure SQL Database connectivity architecture, you can refer to the Azure SQL Database and Azure Synapse Analytics documentation on Microsoft Learn.

    User's image

    Regards

    Geetha


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.