I was getting connection inside the VM using MSSQL Server, but not from outside. After reading some comments, I found that I needed to add a specific port for outgoing traffic and added that port at Azure firewall:
Here are the steps to check is it working for you or not:
- Start
Sql Serverconfiguration Manager - Click on your Server name
- Click SQL Server network config
- Click on protocols
- Click on TCP/IP
- At the end of
/IP range set your port, I set 1433.tcp - Please restart SQL Database.
Now open port at Azure management portal. And connect through SQL tools or other services.
And also remember to open windows firewall.