Reputation: 3258
I have created 2 virtual machines and configured high availability of databases (using SQL Server alwaysOn) Now i want external application to make use of these databases, from the below link it says that I need to create internal listener. https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-windows-classic-ps-sql-int-listener/
Found one more article, but it's not clear which IP I needs to send http://www.cloudcomputingadmin.com/articles-tutorials/windows-azure/configuring-internal-load-balancing-microsoft-azure.html
Example:
Now, when I create internel load balancer, which IP I need to pass in below script for StaticVNetIPAddress ?
Add-AzureInternalLoadBalancer
-ServiceName <service_name>
-InternalLoadBalancerName <name>
-SubnetName <subnet_name>
-StaticVNetIPAddress <ip_address>
Update
I have used below script to find un-used IP and assigned it
Test-AzureStaticVNetIP -VNetName “SubNetName”-IPAddress 10.249.xxx.xxx).AvailableAddresses
Note: The listener IP which you have created during availability group creation will be over written by ILB.
Upvotes: 0
Views: 162
Reputation: 1139
Looking at what you have provided here assuming that 11.240.164.3 is the SQL AlwaysOn listener then you would be looking to pass 11.240.164.4 as the StaticVNetIPAddress parameter.
Just to add to that, you may know this already but the IP address you define has to be within the subnet you define in SubnetName.
Upvotes: 1