Setting SQL Server exclusions

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 sqlbrowser.exe from the server only.

Windows 7:  Click on Start, Control Panel, Windows Firewall.

Windows 8/10: Click the start menu button and start typing "control" without the quotes and choose Control Panel from the search results.  Choose "Windows Firewall" from inside the control panel.

In the Windows Firewall, click on "Allow an app or feature through Windows Firewall".

Setting SQL exclusions in Firewall

Click the "Change Settings" button and then click on "Allow another app...".

Setting SQL exclusions in Firewall

Click on the "Browse" button and then navigate to the sqlservr.exe file.

Sqlservr.exe is located here:  C:\Program Files\Microsoft SQL Server\MSSQL.Instance\MSSQL\Binn\sqlservr.exe

Select the sqlservr.exe file from the list and click OK.  Click on "Allow another app..." again.  Click Browse and now navigate to the sqlbrowser.exe file.

Sqlbrowser exe is located here:  

Windows 32 bit:  C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe

Windows 64 bit:  C:\Program Files(x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe 

**Hint:  If you see a Program Files (x86) folder at all, this means you have a 64 bit Windows.  Go into the x86 version of the Program Files.**

Please note that sometimes even if you have Windows Firewall turned off/disabled, these exclusions still may need to be in place to allow workstations to connect

    • Related Articles

    • 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 ...
    • 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 ...
    • Setting the SQL DSN for KC6 on Windows 10

      From your desktop screen, press the Windows key  + X on your keyboard to bring up the administrative menu.  Choose "Control Panel" or use the search feature built into the task bar and search for "Control Panel". In the upper right hand corner of the ...
    • 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 ...