AlwaysOn Configuration for Azure Internal Load Balencers

gistfile1.ps1

$cloudService="corp-ods-db"
$ilb="corp-ods-lb"
$subnet="AlwaysOn-Static"
$IP="10.10.4.7"
Add-AzureInternalLoadBalancer -ServiceName $cloudService -InternalLoadBalancerName $ilb –SubnetName $subnet –StaticVNetIPAddress $IP

$vmNames=@("corp-ods-db1","corp-ods-db2")
$endPointName="SQLServer"
$prot="tcp"
$localPort=1433
$publicPort=1433
$probePort=59999
$probeProt="TCP"
foreach ($vmName in $vmNames) {
	Get-AzureVM –ServiceName $cloudService –Name $vmName | Add-AzureEndpoint -Name $endPointName -LBSetName "$endPointName-LB" -Protocol $prot -LocalPort $localPort -PublicPort $publicPort –ProbePort $probePort -ProbeProtocol $probeProt -DirectServerReturn $true -InternalLoadBalancerName $ilb | Update-AzureVM
}