top of page
Obrázek autoraFilip Holub

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

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 SUSE please run following comand for allow deafult port 1433 for SQL Server:

Configuration file find here - /etc/sysconfig/SuSEfirewall2

vi - Default editor for UNIX operating system is called vi (visual editor).


After that, you will see somthing like this - scroll down and find this rule FW_SERVICES_EXT_TCP="" :


Right now, you have to put in number of port, in my case it's default port 1433, as you can see below:


For save changes and close edit mode write - :wq

  • w - Write

  • q- Quit


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:

  • Know IP address of your Linux SUSE machine - ip addr

  • Know number of SQL Server port - Default is 1433

  • Know password of SA SQL Login

Connect to Server
Connect to Server

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.

136 zobrazení0 komentářů

Nejnovější příspěvky

Zobrazit vše

Comments


bottom of page