Forum Discussion

Copper Contributor

Mar 24, 2022

Sql server 2019 Linux

Sql server 2019 Linux Good afternoon people, I have a difficult situation here to understand. Someone has had this problem and can help me! I'm testing how sql server works on linux. An Ubuntu ser...

Copper Contributor

Mar 25, 2022

Thank you for your help

It's a clean install. My Linux (ubuntu server 18.04) has nothing installed. A machine created for SQL Server tests.

As I didn't see much explanation for this, I also tested it with other ports, like 230, 240, 250, 888, 999 1000, and it doesn't work.

Starting from port 1024, the exchange works successfully.

I don't understand why I can't use ports below 1024, since this is possible in Windows environment.

Bronze Contributor

Mar 27, 2022

And I don't understand what it could be good for using a port different then default ones, especially one below 1000?

Cristiano705
Copper Contributor
Mar 28, 2022
It's to understand!
I'm testing on Linux and checking for differences in the windows environment.
On windows, any port can be used.
I don't understand why on Linux the Sql server doesn't bind with ports below 1024.
Per Microsoft's post, nothing has changed in Sql Server. I do not understand!
Thanks!
- bake13
  Microsoft
  Mar 28, 2022
  Hi Cristiano705 -- This is likely because ports below 1024 are known as well-known ports (IANA) and on Linux are considered privileged and require root-level privileges to run. This is by design. There are several methods for circumventing that restriction but is generally not recommended. Take care.
  - Cristiano705
    Copper Contributor
    Mar 28, 2022
    Hi! Thanks!
    Yes, ports below 1024 are specific as well.
    On Linux, switching ports is quite simple! change the ftp port (21), or port (80) to any other without any work. There is this facility in Linux
    Already on Sql Server, for Linux it seems not to accept changing ports below 1024, or is there a way?
    
    Thank you for your help!