Problem with connecting Microsoft azure vm MSSql from remote location

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:

  1. Start Sql Server configuration Manager
  2. Click on your Server name
  3. Click SQL Server network config
  4. Click on protocols
  5. Click on TCP/IP
  6. At the end of tcp/IP range set your port, I set 1433.
  7. 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.

PH 832 966 0871

Gulf State Software
720 Rusk st ,1st floor houston tx 77099

© 2021 gulf state software