 Search the Knowledgebase |
 Browse by Category |
|
|
|
|
|
| How do I configure Windows Firewall to allow clients to connect to SQL Server? |
| User Opinions |
100%
0%
(7 votes)
|
|
Thank you for rating this answer.
|
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.
- Click the Exceptions tab
- Click to Add Program. There are 2 .exes that need be added to the Exceptions list
- SQL Server Browser service
- the actual SQL Server service
- To enable these, you will need to browse to the .exe directly.
- c:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
- c:\Program Files\Microsoft SQL Server\[folder which houses your instance name]*\MSSQL\Binn\sqlservr.exe
*Each installation of SQL Server 2005 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:
- Open SQL Server Configuration Manager
- Highlight SQL Server 2005 Services
- On the right side of the split, right-click the ESHA instance, and choose Properties
- Click the Services tab
- Note the Binary Path setting -- particularly the MSSQL.# This is the folder which houses your instance name
|
| Attachments |
|
No attachments were found.
|
| Related Questions |
|
No related questions were found.
|
Print this page
Email this page
Post a comment
Subscribe me
Add to favorites