question

Ashwin-4908 avatar image
0 Votes"
Ashwin-4908 asked SaiKishor-MSFT commented

How to connect to the ip hosted in the VM

hi,

I have created a VM with win OS. i have installed SQL server and my ERP application to it. my software uses SQL as its database. I want to connect to his DB from outside network using the ip address. i tried the ICMP protocol opening suggested in chat support, but no luck. I think if i could get a static ip or could ping the ip from my network this would. appreciate your responses.

azure-vpn-gatewayazure-sql-virtual-machines
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Ashwin-4908 Thank you for reaching out to Microsoft Q&A.

I understand that you want to connect to your VM on Azure from your on-premise. Couple of questions here-

  1. Do you have a VPN from on-premise to Azure and if so, what kind of VPN?

  2. What IP do you use to connect to this IP?

  3. Does your security group on the subnet or VM allow traffic from the source IP (on-premise IP)?

  4. Can you provide a Traceroute output from source to destination for this traffic?

Thank you! Looking forward to your update.



0 Votes 0 ·

Appreciate your response.
1) I was hoping if i set the azure VM to a static ip i wont require to do this VPN thing. I was using using the azure services 6 years back for my software. That time i was given a static ip. So all i had to do this install SQL,SSMS and host my databases. I give the static ip and sql instance along with th DB to connect. its works.

2) my local ipv4. i am trying to connect to the VM private ip 10.0.0.*

3) i have created a NSG with ICMP protocol allowing all

4) Attached the picture. private ip gives request timed out102633-tracert.png


0 Votes 0 ·
tracert.png (39.5 KiB)

I see that you are trying to connect to IP- 20.204.34.226. If you have allowed ICMP All traffic on the NSG, that should work. However, I see that Ping is not getting a response. From what I see, I do not see this traffic reaching the Azure VM i.e., 20.204.34.226. It looks like either the Ping is getting dropped in one of the intermediate routers or the OS is not responding to the ping. Could you please check the following:

  1. Turn off the Windows Firewall temporarily and check if Ping gets a response.

  2. Try to do a TCP Based Ping (make sure to open the respective port in the NSG on the Azure VM) and see if that responds. Check Psping for more details.

  3. Can you share a snapshot of the effective security group for this VM?

Thank you!



0 Votes 0 ·

0 Answers