question

jkreber-4324 avatar image
1 Vote"
jkreber-4324 asked RyanGermann-5499 commented

Why does Azure Data Studio (and SSMS) not honor my VPN IP address?

When I attempt to connect to an Azure Data Warehouse from Azure Data Studio (and SSMS) while on my corporate VPN the connection uses my ISP's IP address and not my VPN assigned IP address. How can we have the connection honor my VPN IP address?

azure-firewall
· 1
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.

Hello,

Just checking in to see if the above answer helped in solving your problem. Kindly let us know if you have any further questions on this specific topic, we would be more than happy to assist you & please do mark the post which was helpful by clicking on Mark as Answer & Up-Vote to help the community find the right answers.

0 Votes 0 ·

1 Answer

suvasara-MSFT avatar image
0 Votes"
suvasara-MSFT answered RyanGermann-5499 commented

Greetings,

Apologies for the delay in response. On Azure portal it is expected to see your ISP IP instead of VPN IP. To establish connection, you need to whitelist your VPN IP in the firewall configuration. Please let us know if you need further assistance in this issue.



Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.




· 2
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.

Hi; would you mind providing a bit more information / specifics?

"whitelist your VPN IP in the firewall configuration".

I am not sure where I would do this configuration:
- In azure data studio itself, telling it which of my networks to use?
- in my local PC firewall?
- Somehow in my VPN software configuration?
- On my local router?
- On my Azure Portal for the VM I want to connect to?


When I have my VPN running, and tried to connect to the Azure PostgreSQL server, the error message I got showed my non-VPN static IP address, not my VPN IP, so if the communication is going out from my computer bypassing my VPN, is there some configuration on my local computer I need to do to ensure that the Azure Data Studio is using the VPN, not just the regular connection?

I am working remotely so I am not on our corporate network.



1 Vote 1 ·

@jkreber-4324,

If you think your question has been answered, click "Mark as Answer" if just helped click "Vote as helpful". This can be beneficial to other community members reading this forum thread.


Best regards
Subhash

0 Votes 0 ·