IP port configuration for servers with more than one MS SQL instance installed.
Posted on 2014-04-15
I'm working on a SQL 2012 standard Server. It's been running a default instance using a specified IP port for some time fine.
Now I have to install another instance on the same server.
Whats the best way to setup IP port configuration?
SHould I set both to dynamic? Keep the first set to a specific port and set the new one to dynamic or give that a fixed port too?
We have a number of apps that have been working well with the default SQL server instance running a specific port so I'm not that keen to change it...
(For info, the server has one fixed IP address)