GHIN Technical Support Checklist for SQL Server Related Errors by qsr20347

VIEWS: 91 PAGES: 7

									     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.

								
To top