Configuring TCP/IP

• Open the SQL Server Configuration Manager and navigate to SQL Server Network Configuration > Protocols for MSSQLServer/'Instance name'. If TCP/IP is disabled, click Enable.
• Open the TCP/IP Properties dialog and switch to the IP Addresses tab.
  • Scroll down to the IP All properties. 
  • If dynamic TCP ports are enabled, the SQL Server Browser service must be run.