Connecting to named Instances Using Port Number

I came across an interesting situation where a developer was trying to connect to a named instance using a DNS alias without specifying the instance name. Coincidently though he remembered to include the port number and miraculously it worked. So it appears that sql server accepts connections to a specific instance based on its port number.

While it may not seem to particularly useful, I can imagine it could be used in the following situations:

  • To mirror to a server with a different instance name (but same port number)
  • To hide the complexity of instance names from end users and just rely on port number (and optionally dns alias)
Published Thursday, December 16, 2010 11:59 AM by blakmk


No Comments