CODEWITHSUNDEEP
azuressmsip-addressvpnazure-sql-server
NiallMitch14
NiallMitch14

Reputation: 1229

Cisco Anyconnect VPN IP Address not being used to connect to Azure SQL Server

I am able to connect to Azure SQL Servers by defining my IP address in the firewall rules for a server. Although due to working from home and having a dynamic IP address, this can become tedious and annoying for other databases that I have to request to get my new IP address added to to gain access.

I have connected to my company's VPN through Cisco Anyconnect VPN. Is it possible for SQL Server Management Studio to use the VPN's IP address to connect to Azure SQL Servers so I can access the server using the VPN? Currently when I'm connected to the VPN and try to connect through SSMS, my public IP address is still being used and says that my address does not have access to the server. How would I be able to configure this to use Cisco Anyconnect VPN's IP address instead?

Upvotes: 0

Views: 907

Answers (1)

Nancy Xiong
Nancy Xiong

Reputation: 28284

When you connect to your company's VPN through Cisco Anyconnect VPN. You should add the outbound public IP address list from your company to the firewall rules for a Azure SQL Server.

You may ask your security admin for the IP lists or check your current Public IP here with connecting VPN connection.

Upvotes: 0

Related Questions