SQL Server Performance

Listening on an additional port?

Discussion in 'SQL Server 2005 General DBA Questions' started by -RJ, Sep 14, 2011.

  1. -RJ Member

    Hello,

    Is it possible to set SQL 2005 to listen to two ports on the same IP address, or do I need to add an IP address to connect on the alternate port?

    Thanks in advance.
  2. preethi Member

  3. satya Moderator

    DYNAMIC ports is nearest possible solution in this case where you can set range in FIREWALL exceptions too.

Share This Page