How to allow port and remotely connect to Management Studio on Ubuntu?
Today I will demonstrate how to allow default port 1433 after installation in order to remotely connect to Management Studio.
"First of all, you have to connect as root user on your Linux machine!"
In Ubuntu please run following comand for allow deafult port 1433 for SQL Server:
Set rule has been updated successfully!
Now, we can open SSMS and try to connect remotely from windows desktop:
You have to know following thins for connnection:S
Know IP address of your Linux Ubuntu machine - ip addr
Know number of SQL Server port - Default is 1433
Know password of SA SQL Login
As you can see, we have connected successfully.