Geek asks and answers

Azure VM SQL Connectivity - Internal IP or Public VIP

I have an Azure SQL Database and Azure Virtual Machine with an application connecting to the database.

  • They are in the same data center and under the same Azure subscription.

  • I added the public virtual IP address of the virtual machine to the list of allowed IP addresses on the portal management server configuration page.

  • Windows Azure Services is marked Yes in the Allowed Services section.

When I try to connect, I get an exception: "The client with the IP address" xxxx "is not allowed to access the server.", Where xxxx is the internal IP address of the virtual machine. I hesitate to use the internal IP address in the allowed IP rule. Should SQL Azure see the public IP address of the virtual machine during the connection?

+5
source share
2 answers

I hesitate to use the internal IP address in the allowed IP rule. Shouldn't SQL Azure see the public IP address of the virtual machine during the connection?

, . , , , IP- Azure:

10.0.0.0 to 10.0.0.255

IP- .

+2

, azure, script. , IP- vm, , .

powershell:

  • New-SqlAzureFirewallRule - Sql Azure .
  • Get-SqlAzureFirewallRules - Sql Azure.
  • -SqlAzureFirewallRule - Sql Azure.

Sql Azure

+1

More articles:


All Articles