September 17, 2009 at 8:08 am
One instance is default, another is a named instance.
What if the two SQL Server database instances on a standalone server share the same IP?
What if the two SQL Server database instances on a standalone server use the same port number?
Any input will be greatly appreciated.
September 17, 2009 at 8:37 am
SQL ORACLE (9/17/2009)
One instance is default, another is a named instance.What if the two SQL Server database instances on a standalone server share the same IP?
What if the two SQL Server database instances on a standalone server use the same port number?
Any input will be greatly appreciated.
Simple, on any given IP address only a single "listener" is allowed. Therefore you could setup a default instance on one ip address at the default port and a named instance on another ip address also on the default port, but you couldn't have both on the same ip address with both having the default port. Also be careful about having both ip addresses in the same subnet, there could be routing issues..
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply