0

Connecting to one of my servers (no mirror or availability group running), from a local machine and I get this error message below related to handshake when the firewall is up.

when the firewall is down it connects straight away.

the question I would like to address is:

is it always these number below (29237 and 26244) that sql server uses for connection?

I am aware of the port numbers on single and multiple instances.

This server by the way is not a named instances.

initialization =29237; handshake=26244

or does it change? if so then - based on what?

we have had issues with one domain controller but I have ruled that out.

enter image description here

I haven't even touched authentication schemas and Kerberos

Improve this question
1
  • 1
    not a 100% sure but as it said "The duration spent..." I would assume that those number are the time spend (probably in milisecond) to do the initialization and the handshake (an not port number)... Does it take about 1 min to get that error ?
    – Dominique Boucher
    Commented Feb 5, 2020 at 14:11

2 Answers 2

Reset to default
1

By default, SQL uses port 1433 and 1434 (if you are using named instance or the DAC connection).

You can validate which port is used using SQL Server Configuration Manager

enter image description here

Improve this answer
0
0

as per the comment by Dominique Boucher those number seems to be indication of time, as per the picture below they vary.

"The duration spent..." I would assume that those number are the time spend (probably in milisecond) to do the initialization and the handshake (an not port number)...

enter image description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.