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.
Hi RJ, I believe this link may be helpful http://www.mssqltips.com/sqlservertip/2493/configuring-sql-server-to-use-multiple-ports/
DYNAMIC ports is nearest possible solution in this case where you can set range in FIREWALL exceptions too.