Named instance connectivity

• ramana3327

  SSCoach

  Points: 19722

  More actions

  May 10, 2022 at 11:04 am

  #4029968

  Hi

  We have a new named instance, I can able to connect using SSMS. However when I ping the instance name, it’s not working. It is enabled for mixed mode & enabled for the remote connections. TCP/IP port is enabled.  I added the 1434 udp port in the firewall. Also changed the dynamic port to static. Any help what other things I have to check

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 11, 2022 at 11:10 am

  #4031048

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• kaj

  SSCommitted

  Points: 1616

  More actions

  May 11, 2022 at 5:06 pm

  #4031257

  What is it you want to achieve?

  PING is a tool that checks a connection to a destination server using ICMP packets. Many firewalls block ICMP from the internet by default.

  https://en.wikipedia.org/wiki/Ping_(networking_utility)

  But it's the server where your SQL server instance is running that replies to the ping. A successful ping doesn't really say anything about whether your instance is up-and-running.

   

• Michael L John

  One Orange Chip

  Points: 27079

  More actions

  May 12, 2022 at 4:24 pm

  #4031921

  A ping will return the server name/IP. It knows nothing of an instance name.

  If your server is named "Server1.yourdomain.com" and the instance is "Instance1", you would be able to connect using Server1.yourdomain.com\Instance1.

  This will fail: PING Server1.yourdomain.com\Instance1

  This will succeed: PING Server1.yourdomain.com

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/