{"id":6738,"date":"2016-05-02T12:00:58","date_gmt":"2016-05-02T12:00:58","guid":{"rendered":"http:\/\/www.top-password.com\/blog\/?p=6738"},"modified":"2016-05-02T12:05:38","modified_gmt":"2016-05-02T12:05:38","slug":"configure-windows-firewall-to-allow-sql-server-access","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/configure-windows-firewall-to-allow-sql-server-access\/","title":{"rendered":"2 Ways to Configure Windows Firewall to Allow SQL Server Access"},"content":{"rendered":"

By default, Windows Firewall doesn’t allow inbound \/ outbound requests for SQL Server. If you try to connect to a SQL Server instance from network, you might get the error saying “The server was not found or was not accessible”. In this tutorial we’ll show you 2 ways to configure Windows Firewall to allow SQL Server access.<\/p>\n

Method 1: Allow SQL Server Access Through Control Panel<\/strong><\/p>\n

    \n
  1. Open Control Panel in Large icons or Small icons view, click on Windows Firewall<\/strong>.\n

    \"windows-firewall\"<\/p>\n<\/li>\n

  2. Click the link “Allow a program or feature through Windows Firewall<\/strong>” on the left of window.\n

    \"allow-app-through-firewall\"<\/p>\n<\/li>\n

  3. You will now see a list with all the apps which are allowed to communicate through the Windows Firewall. To change the rules, you need to click the Change Settings<\/strong> button. The list of rules will no longer be gray and you will be able to edit it.\n

    \"change-firewall-settings\"<\/p>\n<\/li>\n

  4. Click the “Allow another program…<\/strong>” button.\n

    \"add-another-program\"<\/p>\n<\/li>\n

  5. From the “Add a Program” window, click the Browse<\/strong> button.\n

    \"browse-program\"<\/p>\n<\/li>\n

  6. Navigate to the installation path for your SQL Server instance and select sqlservr.exe<\/em>, and click Open<\/strong>. In my example, the location is C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\Binn\\sqlservr.exe<\/code>.\n

    \"sqlserv\"<\/p>\n<\/li>\n

  7. You’ll back to the “Add a Program” window and see SQL Server is added to the list. Click the Add<\/strong> button.\n

    \"add-sql-server\"<\/p>\n<\/li>\n

  8. SQL Server now appears in the list of Allowed programs and features. You can check any of the location types: private or public. When done, press OK<\/strong>.\n

    \"allowed-program\"<\/p>\n<\/li>\n<\/ol>\n

    Method 2: Allow SQL Server Access Through Command Prompt<\/strong><\/p>\n

      \n
    1. \nOpen an elevated Command Prompt.<\/li>\n
    2. \nYou can run the Netsh advfirewall<\/strong> command to open all ports for SQL Server connections. Assuming the path of your SQL Server service is C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\Binn\\sqlservr.exe<\/i>, copy \/ and paste the following commands in the Command Prompt, press Enter after each.<\/p>\n

      netsh advfirewall firewall add rule name=\"SQL Server TCP\" protocol=tcp dir=in action=allow program=\"C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\Binn\\sqlservr.exe\" enable=yes profile=any localip=any localport=any remoteip=any remoteport=any<\/code><\/p>\n

      netsh advfirewall firewall add rule name=\"SQL Server UDP\" protocol=udp dir=in action=allow program=\"C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\Binn\\sqlservr.exe\" enable=yes profile=any localip=any localport=any remoteip=any remoteport=any<\/code><\/p>\n

      \"advfirewall\"<\/p>\n<\/li>\n

    3. \nWhen it’s done, you’ve successfully opened up all ports to allow SQL Server access through Windows Firewall.\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      By default, Windows Firewall doesn’t allow inbound \/ outbound requests for SQL Server. If you try to connect to a SQL Server instance from network, you might get the error saying “The server was not found or was not accessible”. In this tutorial we’ll show you 2 ways to configure Windows Firewall to allow SQL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10,1894,3,39],"tags":[2683,2682],"class_list":["post-6738","post","type-post","status-publish","format-standard","hentry","category-others","category-tips-tricks","category-windows-10","category-windows-7","category-windows-8","tag-allow-sql-server-through-firewall","tag-configure-windows-firewall-for-sql-server"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/6738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=6738"}],"version-history":[{"count":6,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/6738\/revisions"}],"predecessor-version":[{"id":6753,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/6738\/revisions\/6753"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=6738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=6738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=6738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}