Forum Discussion
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...
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!
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
MicrosoftHi 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.
- 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!- > seems not to accept changing ports below 1024, or is there a way?
Why? I can't imagine, what that could be good for?
OlafIf someone has a windows installation of sql, running on a port below 1024, and is going to migrate to a sql server installation on Linux, you will have problems!
You will have to change all sql server connections or work on a firewall configuration to get around the problem.
Why does it lock in Linux, since in windows the port can be changed without problems!Thanks.
Sorry for English! I'm using tractor.
