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.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2009-04-02 : 11:00:29
|
| I need to do a TCP port change from 1433. What other port I can assign? How will i come to know which port are available?Thank you.------------------------I think, therefore I am - Rene Descartes |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-04-02 : 12:20:34
|
| If you bring up a command prompt and run:netstat -an | find "LISTEN"This will tell you which ports are already being used, any port not listed there is available. You should also check with your network administrator to make sure the port you choose is accessible to your end users/applications. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-04-02 : 15:45:11
|
| Thanks - shaunc. The command lists the ports in LISTENING mode. Is there a way to find which application is using the port? Or which ports are free to use?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-03 : 11:09:23
|
| netstat -bFree ports are those that are not in use. |
|
|
|
|
|
|
SQL Server TCP port change.