Enable MS-SQL server to listen on IP addresses

  1. Open SQL server configuration manager
  2. Click into “Protocols for <SQL_INSTANCE>”
  3. Right-click TCP/IP and choose Properties (ensure it’s set to enabled)
  4. Click into the “IP Addresses” tab
  5. There will be a section for each IP address that the machine has – including for the “localhost” address and also for IPv6 addresses
  6. Go through and “Enable” all the IP addresses that are needed.
    1. If you don’t know the correct local IP address, a simple “ping <servername>” will determine which IP address your current machine resolves to when referring to it by it’s hostname
    2. If unsure, consult a SQL or network professional to assist before making any changes.
  7. Click OK
  8. Restart the SQL server via services or the “SQL server services” item in the configuration manager.