How to enable TCP/IP on MS-SQL server

  1. Open the “SQL Configuration Manager”
  2. Expand “SQL Server Network Configuration”
  3. Click into “Protocols for <SQL_INSTANCE>”
  4. Right-click “TCP/IP” and choose “Properties”
  5. Choose “Enabled”
  6. Click OK
  7. Restart the SQL server instance – this can be done from the “SQL server services” item in the configuration manager