If you have just installed SQL Server on Ubuntu Linux and you are trying to connect remotely you may have some difficulty connecting if port 1433 is not available.
Here is how you do it, using the UFW, or Uncomplicated Firewall on Ubuntu.
sudo ufw enable
sudo ufw allow 1433
While you are at it you may want to enable port 22 for SSH if that has not been allowed already. I also allowed 1434 for the dedicated admin console assuming that it is available on the Linux version of SQL Server v.next.
I hope this helps! Enjoy.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
SQL Server on Linux currently supports a couple of distributions of Linux, those being Red Hat, SUSE and Ubuntu, as well as Docker engine.
I have enabled 1433 and 1434 port on Ubuntu firewall but still i am unable to connect sql server through management studio from outside.
This worked for me. Thank you so much.
Thank you very much, worked for me.
This solution did not work for me, but this did: https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te