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
As you can see, we have connected successfully.
Comments