Some of VMs inside of VNET suddenly lost connectivity to Azure SQL and internet

Question

Some of VMs inside of VNET suddenly lost connectivity to Azure SQL and internet

Mait Viljamäe 0

At one moment 2 of 3 VMs lost connectivity to Azure SQL and internet. All VMs are in the same VNET, NSG is applied only in VNET level, no difference in local firewall settings.

Connection troubleshoot on VM gives 'Network connectivity allowed' but when we run Connection troubleshoot on Network Watcher, it fails on the last hop (destination, sql)

ea-web-ws2-sql

on the working VM the result is following ea-web-ws1-sql

Allow Azure services and resources to access this server is checked in SQL server

The same result we get when we test any public internet site.

Can't create the The Support Ticket as VM Connectivity Troubleshooter doesn't detect any issues so no Next step appear.

support_problem

Any idea what could be wrong or how to connect support in such cases?

KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-20T06:29:42.9+00:00
@Mait Viljamäe

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

I understand that you are facing issues with connecting to Internet and Azure SQL from certain VMs.

From your verbatim,

I can see all the requests are going to a certain Public IP, 20.X.X.224 May I ask what this IP/Service is?

Post this, I can see a lot of next Hops before the traffic actually reaches the destination. Can you confirm if this is an expected behavior?

P.S:

To create the support incident,

VM ---> Support+Troubleshooting ---> Create a Support request

Under "Recommended solution", you can click , "Return to Support request"

and continue creating the support request.

Cheers,

Kapil
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-21T09:55:59.62+00:00

@Mait Viljamäe

May I know if you got a chance to review my previous comment?

Please let me know if you are facing any challenges or if there are any follow-up questions, I shall be glad to address them.

Thanks,

Kapil
Mait Viljamäe 0 Reputation points

2023-02-22T10:44:48.8733333+00:00

@KapilAnanth-MSFT

The issue is resolved.

All 3 servers are in Availability Set. When Public IP address was assigned to one of servers, all other lost external connection. After we removed Public IP address from the server, external connection restored on all servers.

Thanks,

Mait
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-23T15:51:05.3966667+00:00

@Mait Viljamäe

Glad the issue has been resolved.

I have summarized the thread and posted it as an answer for the better reachability across the community

Cheers,

Kapil
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-03-09T05:53:47.2366667+00:00

@Mait Viljamäe

Reaching out to check if there are any questions on this.

Please let us know if we can be of any further assistance here.

Thanks,

Kapil

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer

1 answer

Your answer

KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-20T06:29:42.9+00:00

@Mait Viljamäe

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

I understand that you are facing issues with connecting to Internet and Azure SQL from certain VMs.

From your verbatim,

I can see all the requests are going to a certain Public IP, 20.X.X.224 May I ask what this IP/Service is?

Post this, I can see a lot of next Hops before the traffic actually reaches the destination. Can you confirm if this is an expected behavior?

P.S:

To create the support incident,

VM ---> Support+Troubleshooting ---> Create a Support request

Under "Recommended solution", you can click , "Return to Support request"

and continue creating the support request.

Cheers,

Kapil
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-21T09:55:59.62+00:00

@Mait Viljamäe

May I know if you got a chance to review my previous comment?

Please let me know if you are facing any challenges or if there are any follow-up questions, I shall be glad to address them.

Thanks,

Kapil
Mait Viljamäe 0 Reputation points

2023-02-22T10:44:48.8733333+00:00

@KapilAnanth-MSFT

The issue is resolved.

All 3 servers are in Availability Set. When Public IP address was assigned to one of servers, all other lost external connection. After we removed Public IP address from the server, external connection restored on all servers.

Thanks,

Mait
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-02-23T15:51:05.3966667+00:00

@Mait Viljamäe

Glad the issue has been resolved.

I have summarized the thread and posted it as an answer for the better reachability across the community

Cheers,

Kapil
KapilAnanth-MSFT 49,016 Reputation points Microsoft Employee

2023-03-09T05:53:47.2366667+00:00

@Mait Viljamäe

Reaching out to check if there are any questions on this.

Please let us know if we can be of any further assistance here.

Thanks,

Kapil

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer

Answer 1

@Mait Viljamäe

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

I understand that you are facing issues with connecting to Internet and Azure SQL from certain VMs.

From your verbatim,

I can see all the requests are going to a certain Public IP, 20.X.X.224
Post this, I can see a lot of next Hops before the traffic actually reaches the destination. I wanted to know if this is an expected behavior?

You informed us,

You had 3 servers in an Availability set.
You assigned a Public IP address was assigned to one of servers. This resulted in all other servers losing external connection
Removing the Public IP resolved the issue

Cheers,

Kapil

Share via

Some of VMs inside of VNET suddenly lost connectivity to Azure SQL and internet

1 answer

Your answer