top of page
  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon

How to allow port and remotely connect to Management Studio on Ubuntu?

  • Obrázek autora: Filip Holub
    Filip Holub
  • 30. 1. 2019
  • Minut čtení: 1

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
Management Studio

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

Comments


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

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

bottom of page