Connecting to named instance

• kirk.bay

  SSC Rookie

  Points: 32

  More actions

  November 11, 2022 at 7:07 pm

  #4111771

  When connecting to just one specific named instance it will take up to 30 seconds to connect. During that time SSMS will give me a Not Responding message, and eventually the connection happens. Any navigation results in the same Not Responding message.

  This problem does not happen when accessing the instance on the server, so in my mind it rules out any resource issues.

  I've turned off the Windows firewall on my PC and when analyzing with ProcMon, not getting any "access denied" but plenty of other results other than Success.

  Have disabled AV software on my PC to confirm that's not the problem.

  Any thoughts?

  Thanks,

  Kirk

• Eirikur Eiriksson

  SSC Guru

  Points: 182948

  More actions

  November 12, 2022 at 12:01 pm

  #4112023

  Sounds like either a DNS or a network issue, the Browser Service uses UDP/1434.

  😎

• Johan Bijnens

  SSC Guru

  Points: 135551

  More actions

  November 14, 2022 at 10:55 am

  #4112639

  must be a routing issue.

  Check the path ( tracert ) which your connection has to follow to be able to connect to your instance.

  - router/switches/vlans/Wirewalls/...

  • does it also need that much time if you provide the Portnumber to connect to that instance ?

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me