So many times, while connecting the azure Sql Server DB. we will get error message like
“Your client IP address doesn’t have access to server. Sign Into an Azure Account and create firewall rule to enable access.“
Solution for this issue:
Go to the firewall rules of your server and create new rule like given below image.
Note : Give the IP address range which is showing on SSMS error message
Chandradev's Blog 