Named instance connectivity

  • 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

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

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

  • 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.

     

  • 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/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply