Switch on TCP/IP

When using a remote SQL Server, the TCP/IP protocol must be enabled on the remote computer.

  1. In the Start menu, type SQL Server Configuration Manager and click on it to launch the SQL Server Configuration Manager application.
  2. In the browser, select SQL Server Network Configuration > Protocols for [SQL server name].
  3. Right-click the protocol name TCP/IP and select Enable.
info

NOTE:
Depending on the network infrastructure, additional ports must be enabled on the firewall, for example:

‒ TCP Port 1433 for SQL Server
‒ UDP Port 1434 for SQL Server Browser
In Complete the Installation Planning Requirements, see Configure Windows Defender Firewall Settings and Firewall Software.

ss