My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I set up a new instance and needed to connect from another machine. I’ve done this lots of times, but in this case, I wanted to both enable TCP/IP as well as move the port.
This post explains how to get your named instance to listen on 1433.
First, run the Configuration Manager and check your protocols for the server. You likely see something like this, where TCP/IP is disabled.
Right click TCP/IP and enabled it from the menu.
You’ll have to restart the instance, but wait. Cancel the message that appears. Now open the properties for the TCP/IP service.
At the bottom, there’s an IPAll item. This is likely set for Dynamic ports for your named instance. Remove the 0 and enter 1433 for the TCP Port line. You should get something like this:
When you click OK or Apply, you’ll see this message.
Now restart your database engine service and you should be able to connect over 1433.