SQL Server on Azure VM Not Accepting Remote Connection

Peter Jones (BIDA) 86 Reputation points
2022-09-02T09:26:11.887+00:00

Hi Guys,
We are doing our first test with a VM on Azure.

We created a windows 2019 data center edition VM.

We installed sql server 2019 developer edition.

I opened up the ports (1433, 1434) on the windows server.

I believe (first timer) I opened up the ports in the Azure portal properly as well.

But no luck when we try to connect to the SQL Server using the public IP address from a machine here in my office.

The normal "can't see that machine" message.

So I believe I did everything needed.

I am wondering if there is a post anywhere that describes how to make SQL Server on windows server 2019, on Azure, visible via the public IP address to the outside world.

I searched and didn't find one.

I found this but it looks like it's not the right answer.

I am not a network specialist.

https://learn.microsoft.com/en-us/azure/firewall/tutorial-firewall-dnat?source=docs

Thank you in advance for any assistance you may be able to offer us.

Best Regards

Peter

SQL Server on Azure Virtual Machines
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Peter Jones (BIDA) 86 Reputation points
    2022-09-03T15:16:47.497+00:00

    ok, got it working.

    The installation had TCP connections denied in the sql server configuration tool.