Hi there
http://www.chriskempster.com/tipsandhints.html
Run the server network utility GUI, select the appropriate instance. Highlight then enabled protocol (TCP/IP) and hit the properties button, for the default port enter your port numbers seperated by commas, for example: 1433,2433,2432, restart the instance for the changes to take affect and check your sql server logs. You will see something like:
SQL server listening on 163.232.12.3:1433, 163.232.12.3:2433, 163.232.12.3:2432, 127.0.0.1:1433, 127.0.0.1:2433, 127.0.0.1:2432.
SQL Server is ready for client connections
Remember not to use 1434, which is a reserved UDP port for SQL Server.
Cheers
Ck
Chris Kempster
http://www.chriskempster.com
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"