Follow

How do I configure Windows Firewall to allow clients to connect to SQL Server?

ESHA software uses SQL Server to host the ESHA Database.  When the database resides on a separate machine (often a Server computer), there is need to allow SQL Server as an exception if Windows Firewall is enabled.

To allow this exception, get into Windows Firewall (found in the Control Panel).  Depending on your operating system, your Firewall display may vary, but the concepts hold true. There is also a batch file attached that was created by Microsoft that can open all that is needed.

OpenSQLServerPort.bat

  1. Click "Allow an app or feature through Windows Firewall"
  2. Click to "Allow another app...".  There are 2 .exes that need be added to the Exceptions list
    1. SQL Server Browser service
    2. the actual SQL Server service
  3. To enable these, you will need to browse to the .exe directly.
    1. c:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
    2. c:\Program Files\Microsoft SQL Server\[folder which houses your instance name]*\MSSQL\Binn\sqlservr.exe

*Each installation of SQL Server includes an instance name, and has a corresponding folder housing that sqlservr.exe. To allow the ESHA program access, the proper .exe must be allowed as an exception. To find which is the proper folder:

    1. Open SQL Server Configuration Manager
    2. Highlight SQL Server 2005 Services
    3. On the right side of the split, right-click the ESHA instance, and choose Properties
    4. Click the Services tab
    5. Note the Binary Path setting -- particularly the MSSQL.# This is the folder which houses your instance name
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk