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.

© 2024 gulf state software