What ports does SQL Server use on Linux?
What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
sql-server linux network
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
add a comment |
What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
sql-server linux network
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
add a comment |
What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
sql-server linux network
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
sql-server linux network
sql-server linux network
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
asked Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
32.7k971222
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Assuming the defaults, there are two ports SQL Server listens on which can be verified with netstat -ln,
ms-sql-sTCP 1433 for the serverms-sql-mTCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on127.0.0.1only. For more information see "remote admin connections Server Configuration Option"
While my install was only listening for TCP connections, /etc/services shows entries for UDP too,
ms-sql-s 1433/tcp # Microsoft SQL Server
ms-sql-s 1433/udp
ms-sql-m 1434/tcp # Microsoft SQL Monitor
ms-sql-m 1434/udp
The "Microsoft SQL Monitor" is the DAC connection.
The log also shows similar information,
spid19s Server is listening on [ 'any' <ipv6> 1433].
spid19s Server is listening on [ 'any' <ipv4> 1433].
Server Server is listening on [ ::1 <ipv6> 1434].
Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222569%2fwhat-ports-does-sql-server-use-on-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Assuming the defaults, there are two ports SQL Server listens on which can be verified with netstat -ln,
ms-sql-sTCP 1433 for the serverms-sql-mTCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on127.0.0.1only. For more information see "remote admin connections Server Configuration Option"
While my install was only listening for TCP connections, /etc/services shows entries for UDP too,
ms-sql-s 1433/tcp # Microsoft SQL Server
ms-sql-s 1433/udp
ms-sql-m 1434/tcp # Microsoft SQL Monitor
ms-sql-m 1434/udp
The "Microsoft SQL Monitor" is the DAC connection.
The log also shows similar information,
spid19s Server is listening on [ 'any' <ipv6> 1433].
spid19s Server is listening on [ 'any' <ipv4> 1433].
Server Server is listening on [ ::1 <ipv6> 1434].
Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
add a comment |
Assuming the defaults, there are two ports SQL Server listens on which can be verified with netstat -ln,
ms-sql-sTCP 1433 for the serverms-sql-mTCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on127.0.0.1only. For more information see "remote admin connections Server Configuration Option"
While my install was only listening for TCP connections, /etc/services shows entries for UDP too,
ms-sql-s 1433/tcp # Microsoft SQL Server
ms-sql-s 1433/udp
ms-sql-m 1434/tcp # Microsoft SQL Monitor
ms-sql-m 1434/udp
The "Microsoft SQL Monitor" is the DAC connection.
The log also shows similar information,
spid19s Server is listening on [ 'any' <ipv6> 1433].
spid19s Server is listening on [ 'any' <ipv4> 1433].
Server Server is listening on [ ::1 <ipv6> 1434].
Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
add a comment |
Assuming the defaults, there are two ports SQL Server listens on which can be verified with netstat -ln,
ms-sql-sTCP 1433 for the serverms-sql-mTCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on127.0.0.1only. For more information see "remote admin connections Server Configuration Option"
While my install was only listening for TCP connections, /etc/services shows entries for UDP too,
ms-sql-s 1433/tcp # Microsoft SQL Server
ms-sql-s 1433/udp
ms-sql-m 1434/tcp # Microsoft SQL Monitor
ms-sql-m 1434/udp
The "Microsoft SQL Monitor" is the DAC connection.
The log also shows similar information,
spid19s Server is listening on [ 'any' <ipv6> 1433].
spid19s Server is listening on [ 'any' <ipv4> 1433].
Server Server is listening on [ ::1 <ipv6> 1434].
Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
Assuming the defaults, there are two ports SQL Server listens on which can be verified with netstat -ln,
ms-sql-sTCP 1433 for the serverms-sql-mTCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on127.0.0.1only. For more information see "remote admin connections Server Configuration Option"
While my install was only listening for TCP connections, /etc/services shows entries for UDP too,
ms-sql-s 1433/tcp # Microsoft SQL Server
ms-sql-s 1433/udp
ms-sql-m 1434/tcp # Microsoft SQL Monitor
ms-sql-m 1434/udp
The "Microsoft SQL Monitor" is the DAC connection.
The log also shows similar information,
spid19s Server is listening on [ 'any' <ipv6> 1433].
spid19s Server is listening on [ 'any' <ipv4> 1433].
Server Server is listening on [ ::1 <ipv6> 1434].
Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
edited Nov 14 '18 at 21:14
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
answered Nov 14 '18 at 20:27
Evan CarrollEvan Carroll
32.7k971222
32.7k971222
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222569%2fwhat-ports-does-sql-server-use-on-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
