May 28, 2014 at 2:38 am
Hi All,
At present SQL 2008 instance is running on dynamic port and client want to change it to static port.
What are precautions need to take for choosing a Static Port?what characteristics it should satisfy?
AT present the dynamic port is 50123 and can we use same port for the static port?
From application side ,do they required to update on config file or connection string on application server.
Many Thanks.
May 28, 2014 at 12:12 pm
You should be able to use the same port. The dynamic port number is just a preferred port for the service. If on startup, the port is in use by another process, the server will try to grab a different one.
If you happen to change the port number, be sure to update any firewall rules to allow the traffic through. Applications should not need to be updated, as most connections should address the server's instance name, rather than the port.
May 30, 2014 at 12:39 pm
I would also ask "why was the port made 'dynamic' in the first place?"
If it is on a standalone SQL Server "Why", "Security or some other policy driven reason"
However if it is on an active/active cluster or an N+1 node cluster with either N or N+1 SQL instances the situation is more complex.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply