• Filip Holub

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.


Management Studio

I know, it was very short post. I hope that you learned something new.

27 zobrazení
SIGN UP AND STAY UPDATED!
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. MSSQLONLINUX.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon