I have built a named instance which is running on a static port, 50101.
The network guys have opened the port on the firewall to allow incoming connections. I have asked them open UDP port 1434 too, as I believe the SQL Browser Service runs on this port and needs to pass the correct port for the named instance back to the requesting connection. Even if the named instance is running on a static TCP port.
Is that correct?
SQL Browser / UDP 1434 is not just for dynamic ports, right?
It needs to be open if the port is not explicit in the connection string?
Really need to end this argument!