How can I configure SQL Server to listen on multiple TCP/IP ports?

Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click TCP\IP to open the TCP\IP protocol properties. Select the IP Address tab and in IP All specify the port numbers separated by commas, for example: 1433,2433,2432. Ensure dynamic ports are disabled. Settings are shown in snapshot below:

Continue reading