Adding SQL Server Exceptions to Windows Firewall

Adding SQL Server Exceptions to Windows Firewall

Adding SQL Server Exceptions to Windows Firewall

Adding SQL Server exceptions to Windows Firewall

In order to allow workstations to connect to SQL Server on your main/server computer, Windows Firewall exceptions will need to be added.  Complete the follow steps on your main/server computer.


Open Windows Firewall panel.  


Windows 7 users:  Click Start, Control Panel.  


Windows 8/10 users: Cliek the Windows start button and start typing "control" click "Control Panel' in the search results.

Inside of Control Panel, in the upper right hand corner, change to View by Small icons.  Then choose Windows Firewall.


Adding exclusions to firewalls


Click on "Allow an app or feature through Window Firewall" on the left hand side menu.


Adding exclusions to firewalls


Click on "Change Settings" in the upper right and then click on "Allow another app" button to choose your files.


Adding exclusions to firewalls


Click the "Browse" button next to the "Path" field and browse for the first file:

C:\Program Files\Microsoft SQL Server\SQL Instance Name\MSSQL\Binn\sqlservr.exe  

Click on sqlservr.exe file and then click "Open".  Click "Add".

Click "Allow another app" and click "Browse" for the second file 

32 bit computers (without a Program Files(x86)) folder:
C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
64 bit computers (with a Program Files(x86)) folder: 
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

32 bit computers (without a Program Files(x86)) folder:C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe

64 bit computers (with a Program Files(x86)) folder: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

Click on the sqlbrowser.exe file and click "Open".  Click "Add".

Close out of the Firewall exception panel and then close the Control Panel.  These entries should allow your networked workstations to connect to your SQL Server.  if you use any other antivirus or third party firewalls, you will need to add the same exceptions to that software as well.


    • Related Articles

    • Setting SQL Server exclusions

      Setting SQL Server exclusions When running the SQL database version of Kennel Connection, SQL and SQL Browser must be excluded from the Firewall in order for your workstations to connect.  Do the following steps. Exclude sqlservr.exe and ...

    • Excluding Kennel Connection 7 from antivirus and firewall applications

      One of most important parts of your computer program is its antivirus program. Not having one leaves you vulnerable to viruses, which can wreck your software and steal information like bank accounts, passwords, login IDs, and so on. However, unless ...

    • SQL Server 2014 Express Setup Guide

      SQL Server 2014 Express Setup Guide SQL Server 2014 Express is a free download, available from Microsoft. This article will guide you through the process of acquiring, installing and configuring SQL Server 2014 Express so that you can use it with ...

    • Adding Anti-virus exceptions for Live Access and auto update

      After installing the Kennel Connection update 7.07, your KC7 folder will contain a few new application files. While most anti-virus programs do not interfere with these, there are some that will block new files accessing the Internet. We strongly ...

    • Windows 10 Upgrade troubleshooting guide

      Microsoft has recently begun forcing the upgrade to Windows 10 on some machines.  During this upgrade, some network, SQL server, and printing settings have been getting changed or returned to default.  In some cases, this has caused issues opening ...
    After-Hours Emergency Support
    For use ONLY outside of business hours. (Mon-Fri, 8am to 7pm ET). 

    To avoid any delay, be sure to search this knowledgebase for your issue prior to submitting a ticket. Most answers can be found here.

    If you're issue does NOT consist of one of the following, please email support@kennelconnection.com with your issue to create a ticket and someone will get back to you on the next business day. 

    - Kennel Connection Desktop - Will not open on any machine including server. 
    - KC-Cloud - Cannot login/spinning and you've verified you have Internet.
    - KC Online Reservations - Clients are getting an error upon login or cannot book ANY reservations.
    - Hello-Groom - Cannot login/spinning and you've verified you have Internet.
    - Credit Card Processing - Cannot take payments at all from any method.
    - PawLoyalty - Cannot login/spinning or extreme latency and you've verified you have Internet.

    *Utilizing the emergency support for non-emergencies will not receive a call back.
    *Users without a valid subscription will not receive a call back and will need to speak with a sales representative on the next business day.