Switch on TCP/IP
When using a remote SQL Server, the TCP/IP protocol must be enabled on the remote computer.
- In the Start menu, type SQL Server Configuration Manager and click on it to launch the SQL Server Configuration Manager application.
- In the browser, select SQL Server Network Configuration > Protocols for [SQL server name].
- Right-click the protocol name TCP/IP and select Enable.
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