{"id":2456,"date":"2013-10-31T15:23:57","date_gmt":"2013-10-31T05:23:57","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=2456"},"modified":"2014-10-13T12:08:47","modified_gmt":"2014-10-13T02:08:47","slug":"enable-ms-sql-server-to-listen-on-ip-addresses","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=2456","title":{"rendered":"Enable MS-SQL server to listen on IP addresses"},"content":{"rendered":"
    \n
  1. Open SQL server configuration manager<\/li>\n
  2. Click into “Protocols for <SQL_INSTANCE>”<\/li>\n
  3. Right-click TCP\/IP and choose Properties (ensure it’s set to enabled)<\/li>\n
  4. Click into the “IP Addresses” tab<\/li>\n
  5. There will be a section for each IP address that the machine has – including for the “localhost” address and also for IPv6 addresses
    \n\"\"<\/a><\/li>\n
  6. Go through and “Enable” all the IP addresses that are needed.\n
      \n
    1. If you don’t know the correct local IP address<\/strong>, a simple “ping <servername>” will determine which IP address your current machine resolves to when referring to it by it’s hostname<\/li>\n
    2. If unsure, consult a SQL or network professional to assist before making any changes.<\/li>\n<\/ol>\n<\/li>\n
    3. Click OK<\/li>\n
    4. Restart the SQL server via services or the “SQL server services” item in the configuration manager.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Open SQL server configuration manager Click into “Protocols for <SQL_INSTANCE>” Right-click TCP\/IP and choose Properties (ensure it’s set to enabled) Click into the “IP Addresses” tab There will be a section for each IP address that the machine has – … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2456"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2456"}],"version-history":[{"count":2,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2456\/revisions"}],"predecessor-version":[{"id":2740,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2456\/revisions\/2740"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2456"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}