Azure database connection error.
This question already has an answer here:
Windows Azure Client with IP address 'XXX.XXX.XXX.XX' is not allowed to access the server
One Solution collect form web for “Azure database connection error.”
There is IP restriction for accessing Azure Database.
1.You need to add your Public IP to the allowed Ip address on the Azure ManageMent Portal.
You can get the answe from here.