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
>
Showing posts with label bonehead. Show all posts
Showing posts with label bonehead. Show all posts
Monday, March 19, 2012
Changing SQL Port
Sorry for the bonehead questions, but how do I go about changing the SQL 2005
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
>
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
>
Subscribe to:
Posts (Atom)