Configuring the Windows Vista Firewall for Microsoft SQL Server 2000 Desktop Engine This document details the process for allowing an exception in the Windows Firewall that comes standard with the Windows Vista family of Operating Systems. By Default, the Windows Vista Firewall is turned on and all inbound and outbound network connections are blocked. While this document may be used as a guide for creating exceptions in other Firewall Software, it is written for the Windows Vista Firewall. Please follow the steps outlined. It is important that all instructions be followed in the proper sequence as set forth below. ALLOWING AN EXCEPTION 1. Open the Windows Security Center from the Control Panel: Click the Start Button and select Control Panel. From the Windows Control Panel click ‘Allow a program through Windows Firewall’. 2. Windows needs your permission to continue: After clicking ‘Allow a program through Windows Firewall’, you may be prompted by the Windows Vista User Account Control that Windows needs your permission to continue. Click the ‘Continue’ button to proceed with allowing an exception. 3. Managing the Windows Firewall: By default the Windows Firewall is enabled and all inbound network connections are blocked by the Windows Vista family of Operating Systems. While selecting ‘Off’ will allow access to the Microsoft SQL Server 2000 Desktop Edition, this will increase the risk that the security of your computer might be compromised. Turning off the Windows Firewall is not recommended. The preferred method is to configure an exception for the Windows Firewall. To begin the process of creating an exception, click the ‘Exceptions’ tab to continue. 4. Adding a Program: The ‘Exceptions’ tab will now be displayed. A list of Programs and Services that allow inbound and outbound network connections is displayed. To allow an exception is like poking a hole through the Windows Firewall. Before you can add an exception to the Windows Vista Firewall, you must be logged on to the computer as an administrator. To add a new program to the Exceptions list, click the ‘Add Program’ button that is located below the ‘Programs or Port’ list box. 5. Browsing for the Program: The ‘Add a Program’ window will now be displayed. A list of Programs that are currently allowed is displayed. To add a new program, click the ‘Browse. . .’ button below the ‘Programs’ list box. 6. Browsing for the Program: The ‘Browse’ window will now be displayed. Navigate to ‘Program Files\Microsoft SQL Server\MSSQL$GHINGHP\Binn and click the ‘Open’ button to set the Program path. You can also select the MSSQL$GHINTPP named instance if you do not have the GHIN Handicap Program Version 5 installed. Click the ‘Open’ button to continue. 7. Adding the Program: The ‘Add a Program’ window will now be displayed. A list of Programs that are currently allowed is displayed, now including the program ‘sqlserver.exe’. Click the ‘OK’ button to complete the process of adding an exception for the program ‘sqlserver.exe’ to the Windows Firewall. 8. Network Considerations: An exception to access to the Microsoft SQL Server 2000 Desktop Edition must be configured on the GHIN Server and all of the GHIN Workstations within the GHIN Network. Since the Microsoft SQL Server 2000 Desktop Edition operates as a service or process that is separate from any application, you do not have to individually configure exceptions for the GHIN Handicap Program version 5 and the Tournament Pairing Program version 4. One Firewall exception will allow both applications to operate.
Pages to are hidden for
"GHIN Technical Support Checklist for SQL Server Related Errors"Please download to view full document