For a named sql server instance, can we change dynamic port to named port ?

Question

May I know whether we can change for newly created named instance with default port TCP 1433 or do we keep the dynamic port as same.

Answer 1

if you can only have one sqlserver per port. You can make a named instance the default instance by assigning it to port 1433. you also assign it to any port number. you could then connect by the host port number or by the named instance name. if you use firewall rules, you should assign the port numbers.

note: by default named instances use a dynamic port. the client call the sqlbrowser (port 1434) to get the port number (this will work even with assigned ports)

Answer 2

You can set any port for your named instance, as long as it is not clashing with something else. So you can use port 1433 if you don't have a default instance on the machine - or you have set that default instance to listen to a different port.

By the way, the "dynamic" port is that overly dynamic. SQL Server will stick to the port it was assigned at installation. It will only change if it finds when startinh up that some other process has already taken that port. But since SQL Server typically starts when the OS starts, that is not extremely likely.

Answer 3

yes you can set port 1433 for your named instance as long as default instance use different port