November 1, 2013 at 10:28 pm
Hi at one of the client i have to suggest him a port other then default.Can anybody tell me how to proceed with it .I mean how to select a port and can any port be suggested
Regards
Anoop
November 4, 2013 at 4:32 am
query the file C:\windows\system32\drivers\etc\services and find a free port. perform a netstat -n to confirm that no other service on the machine is listening on that port.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2013 at 2:42 pm
I agree with Perry. In our environment, we have used a port up over 8000 away from any system ports, but checking for the available ports would be your best bet. Then you'll need to make sure any firewalls that the servers traverse have that port open for TCP connections. A lot of places open up 1433 because that is the standard SQL port; just something to keep in mind.
November 5, 2013 at 7:51 pm
Perry is right - use a netstat -n to find ports that are in use then simply pick a different one. I'd avoid the known standards like 1433 and 1434. Ones like 21, 22 and 80 are also out, but that leaves a lot of open territory.
I find it helpful to pick ones that mean something to me so I'll remember them and not get them confused with other servers.
November 5, 2013 at 8:04 pm
Ed Wagner (11/5/2013)
Perry is right - use a netstat -n to find ports that are in use then simply pick a different one. I'd avoid the known standards like 1433 and 1434. Ones like 21, 22 and 80 are also out, but that leaves a lot of open territory.I find it helpful to pick ones that mean something to me so I'll remember them and not get them confused with other servers.
I usually avoid 2866 and 2868 too, since a lot of companies just double 1433 and 1434 and these will be the next port they try.
November 6, 2013 at 12:03 am
A port in the high end range is usually good, say 50000 - 60000.
Where firewalls are in place and you wish to connect via the instance name you'll need the following ports opened
TCP. 1433, 1434, your chosen port
UDP. 1434
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 12:10 am
Perry Whittle (11/6/2013)
A port in the high end range is usually good, say 50000 - 60000.Where firewalls are in place and you wish to connect via the instance name you'll need the following ports opened
TCP. 1433, 1434, your chosen port
UDP. 1434
Hi thanks everybody for reply
@perry Whittle how can i determine which port above 50000 is tcp/udp port
November 7, 2013 at 9:19 am
anoop.mig29 (11/7/2013)
Perry Whittle (11/6/2013)
A port in the high end range is usually good, say 50000 - 60000.Where firewalls are in place and you wish to connect via the instance name you'll need the following ports opened
TCP. 1433, 1434, your chosen port
UDP. 1434
Hi thanks everybody for reply
@perry Whittle how can i determine which port above 50000 is tcp/udp port
All ports have a TCP and UDP assignment.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 9:34 am
There's a list here of well known ports: http://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers
In the past, we've typically gone with 51433, just to make it easy for people connecting. However check to be sure it's not being used. Your network admins could also help you determine if there is any traffic using this port on your network.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply