{"id":9435,"date":"2009-02-17T12:08:00","date_gmt":"1999-11-29T20:00:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=9435"},"modified":"2009-02-17T12:08:00","modified_gmt":"1999-11-29T20:00:00","slug":"configure-a-windows-firewall-for-database-engine-access","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=9435","title":{"rendered":"Configure a Windows Firewall for Database Engine Access"},"content":{"rendered":"<\/p>\n<p>This is an <a title=\"important read\" href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms175043.aspx\">important read<\/a> if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server.\u00a0 Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server.\u00a0 Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_wpcom_ai_launchpad_first_post":false,"footnotes":""},"categories":[39],"tags":[],"class_list":["post-9435","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=9435\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=9435\" \/>\n\t\t<meta property=\"article:published_time\" content=\"1999-11-29T20:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"1999-11-29T20:00:00+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#article\",\"name\":\"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro\",\"headline\":\"Configure a Windows Firewall for Database Engine Access\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"},\"datePublished\":\"2009-02-17T12:08:00+00:00\",\"dateModified\":\"2009-02-17T12:08:00+00:00\",\"inLanguage\":\"en-GB\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#webpage\"},\"articleSection\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#listItem\",\"name\":\"Configure a Windows Firewall for Database Engine Access\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#listItem\",\"position\":3,\"name\":\"Configure a Windows Firewall for Database Engine Access\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435\",\"name\":\"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro\",\"description\":\"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9435#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2009-02-17T12:08:00+00:00\",\"dateModified\":\"2009-02-17T12:08:00+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro","description":"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.","canonical_url":"https:\/\/aidanfinn.com\/?p=9435","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=9435#article","name":"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro","headline":"Configure a Windows Firewall for Database Engine Access","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9435#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"},"datePublished":"2009-02-17T12:08:00+00:00","dateModified":"2009-02-17T12:08:00+00:00","inLanguage":"en-GB","mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=9435#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=9435#webpage"},"articleSection":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=9435#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com\/","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","position":2,"name":"SQL","item":"https:\/\/aidanfinn.com\/?cat=39","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=9435#listItem","name":"Configure a Windows Firewall for Database Engine Access"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=9435#listItem","position":3,"name":"Configure a Windows Firewall for Database Engine Access","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9435#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9435#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=9435#webpage","url":"https:\/\/aidanfinn.com\/?p=9435","name":"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro","description":"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=9435#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2009-02-17T12:08:00+00:00","dateModified":"2009-02-17T12:08:00+00:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro","og:description":"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.","og:url":"https:\/\/aidanfinn.com\/?p=9435","article:published_time":"1999-11-29T20:00:00+00:00","article:modified_time":"1999-11-29T20:00:00+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"Configure a Windows Firewall for Database Engine Access | Aidan Finn, IT Pro","twitter:description":"This is an important read if running secured servers, e.g. Windows Server 2008, with SQL on them and clients should be able to access services running on the server. Your Windows Firewall will be up so you need to open ports, e.g. TCP 1433 needs to be open inbound for database service access.","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"9435","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:14","updated":"2025-06-04 12:35:04","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=39\" title=\"SQL\">SQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tConfigure a Windows Firewall for Database Engine Access\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com\/"},{"label":"SQL","link":"https:\/\/aidanfinn.com\/?cat=39"},{"label":"Configure a Windows Firewall for Database Engine Access","link":"https:\/\/aidanfinn.com\/?p=9435"}],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9435"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9435\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}