Forum Discussion
Cristiano705
Mar 24, 2022Copper Contributor
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...
olafhelper
Mar 25, 2022Bronze Contributor
Why doesn't it work on port 220 on Linux!
Cristiano705 , has nothing directly to do with the OS.
One IP port can be used by one application at the same time.
Port 220 is default for IMAP, see List of TCP and UDP port numbers - Wikipedia
And so I simply guess, you installed on Linux a services using that IP port.
Olaf
Cristiano705
Mar 25, 2022Copper Contributor
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.
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.
- olafhelperMar 28, 2022Bronze ContributorAnd I don't understand what it could be good for using a port different then default ones, especially one below 1000?
- Cristiano705Mar 28, 2022Copper ContributorIt'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!- bake13Mar 28, 2022
Microsoft
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.