Server Network Utility - Default Ports

  • Falling asleep here (did not say what SRV does). The SRV record permits the publication of port (tcp, udp, ...). This allows the clients to querry for service ports instead of having a fixed or configurable parameter.

  • I would like to use DNS to enable easy failover and/or server switching. The only problem is with Named Instances. Connecting to sql.domain.com works fine, but connecting to sql.domain.com\instance1 or sql.domain.com:1434 does not work, at least from Query Analyzer. I have yet to try it from a Connection String in an ASP. Any thoughts?

  • The best way to handle this is to keep the instance name and port the same between boxes so that when it fails the only thing you'll need to know is the new ip. Clustering works the same way ... when server\instance fails it's IP gets assigned to a different machine but end users still connect to server\instance.

  • I agree with danw. Set a standard port per instance for your company and use it.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 4 posts - 16 through 18 (of 18 total)

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