assigning static ports to an instance

Question

assigning static ports to an instance

insect.astronaut

Valued Member

Points: 53
More actions
August 18, 2016 at 3:40 pm

#400592

Hi,
In configuration manager, Procotols for "InstanceName" > TCP All
When assigning a static port, what rules govern which IP address I can set as static? Obviously I can't use a port that's in use, but what other restrictions?
For example, could I use the currently assigned Dynamic Port and set it as static? Would that cause any issues?
Thanks in advance!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Usually that will work. You'd generally want to work through this with whoever is managing the network since it does impact that area. You can find some tips about using non-standard ports (there are various things to consider) in this article:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/03/03/running-sql-server-default-instance-on-a-non-default-or-non-standard-tcp-port-tips-for-making-application-connectivity-work/

And this article here on SSC lists the default ports used and has some information on ports you can use:

http://www.sqlservercentral.com/articles/networking/75481/

Sue