TCP Ports - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

TCP Ports

Author

Topic

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2015-01-05 : 23:46:34

We have used Default Port 1433 for an instance and another Instance is allocated with 1434, which is fine under the same server. But if required to have other TCP PORT numbers for other instances what other POSSIBLE TCP PORTS Can be used.

Please advise for where I can get the LIST OF POSSIBLE TCP PORT NUMBERS.

Many Thanks

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-06 : 01:52:30

Any other tcp port is ok, as long as it's not used by another service. I normally configure with dynamic tcp port, which allows the system to set the tcp port.
If you set up the instance and want to find the tcp port - use this script
http://www.sqlserver-dba.com/2012/10/sql-server-find-sql-server-tcp-port-with-powershell.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2015-01-11 : 23:47:23

Thanks

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-12 : 01:46:41

Avoid using tcp port 1433

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources