July 30, 2003 at 9:47 am
My company has mandated that new systems will be developed using different SQL Server ports. Can SQL Server listen on more than one port? How can I add ports?
Any help is appreciated.
- Greg
July 31, 2003 at 2:59 am
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
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"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply