Forcing SQL Server (Express) 2016 to listen on TCP Port 1433
...so I had to configure SQL Server on a new machine (for regression testing of Apache Oak, in case you wonder...).
Found the installer, followed instructions, opened Firewall, no luck.
Googled for instructions, found Enable or Disable a Server Network Protocol - still no success.
In the end what worked for me (in the Configuration Manager) was to open the tab "IP Adresses" and to set the "TCP Port" to 1433 under the last entry "IPALL":
Does it really need to be that hard?
Found the installer, followed instructions, opened Firewall, no luck.
Googled for instructions, found Enable or Disable a Server Network Protocol - still no success.
In the end what worked for me (in the Configuration Manager) was to open the tab "IP Adresses" and to set the "TCP Port" to 1433 under the last entry "IPALL":
Does it really need to be that hard?
