Changing SQL Port

Sorry for the bonehead questions, but how do I go about changing the SQL 200
5
port of 1433? Also, does it matter what I change it to, as long as its in
between 0-65,535?You can change the port in the SQL Server Configuration Manager tool, using
the Protocols for MSSQLSERVER folder and the TCP/IP properties dialog.
To find used ports which need avoiding you can use "NETSTAT -an" from the
command line, or check with your network guys.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hi,
To add on to Paul; After changing the port just restart the SQL Server
service to make the new port to listen on.
Thanks
Hari
SQL Server MVP
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uda07%23$zGHA.4116@.TK2MSFTNGP02.phx.gbl...
> You can change the port in the SQL Server Configuration Manager tool,
> using the Protocols for MSSQLSERVER folder and the TCP/IP properties
> dialog.
> To find used ports which need avoiding you can use "NETSTAT -an" from the
> command line, or check with your network guys.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>