You are in Support

How to install the HandicapMaster Network Edition

Installation on the SQL Server Computer

Pre-requisites

Please check that your hardware and software meet the requirements to run SQL Server 2005 Express.

The installation of SQL Server 2005 Express will require administrator access.

It is also good data processing practice to take backups of your data prior to performing this installation.

Please note: Due to the database technology used by HandicapMaster Club and Premier editions it is not possible to restore a backup from these into Network edition. If you wish to migrate data from Club or Premier Edition to Network edition please contact us and we will be pleased to assist.

If you require further detailed information about SQL Server 2005 Express this is available from Microsoft.

Otherwise please follow the instructions below to install SQL Server and HandicapMaster on the Server Computer.

1. Download and Install HandicapMaster

   1. Download the HandicapMaster Network Server Installer.

   2. Run the Hm_Network_Server_Setup_008.exe installer to install HandicapMaster.

      This will install HandicapMaster and SQL Server 2005 Express. It will then run a Configuration utility to install a HandicapMaster database into SQL Server.

      If the .Net Framework 2.0 library is required, this installer will download it from the Microsoft web site as it is run.

      HandicapMaster SQL Server 2005 Installation This installer will install SQL Server 2005 Express Edition, as follows: An SQL Server instance called HANDICAPMASTER will be installed. The password for the SA account for this instance will be 'GolfClub123'. We strongly recommend this is changed after finishing installation.

      
      

      When the "HandicapMaster SQL Server Configuration Utility" runs, select a suitable folder for HandicapMaster to maintain backups:

      
      

      When the configuration utility completes, make a note of the connection details. You will need these when you run HandicapMaster:

      
      

   3. Download and Install SQL Server 2005 Management Studio Express.

      This is a program that may be run to administer SQL Server, if required.

      NOTE: If you are installing SQL Server 2005 Management Studio Express on a 64-bit version of Windows 7, please follow these additional instructions for this step.

2. Configure SQL Server to allow access from other Computers on the Network

   The default installation of SQL Server does not enable Network access so you will need to enable this using the "SQL Server Configuration Manager" which is installed as part of the "SQL Server 2005 Express" installation.

   1. Start the SQL Server Configuration Manager. From the "Start" bar select All Programs --> "Microsoft SQL Server 2005" --> "Configuration Tools" --> "SQL Server Configuration Manager".

   2. Double click on "SQL Server 2005 Network Configuration", then click "Protocols for HANDICAPMASTER". Check TCP/IP protocol is Enabled.

   3. Configure TCP/IP Port
      Now configure a port for the SQL server to listen for network requests. By default SQL server uses port 1433, however for security reasons you may wish to use an alternative port.
      If you are unsure of a suitable value please discuss this with your network administrator.
      
      Double click the TCP/IP protocol entry, then click 'IP Addresses' Tab
      
      In the 'IPAll' section at the bottom of the list, delete any value for "TCP Dynamic Ports" (do not leave this value as 0 (the default) it MUST be 'blank' to turn off Dynamic Ports).
      Enter a port value of 1433 in "TCP Port" and click OK to save these changes.
      

      
      

   4. Restart SQL Server 2005 Services

      1. In the left hand column, click and highlight "SQL Server 2005 Services".
      2. On the right hand side click and highlight "SQL Server (HANDICAPMASTER)", then right-click and select 'Restart'.

      Please note it can take a short time for SQL Server to stop and restart.

3. Run HandicapMaster

   Start up HandicapMaster either by double clicking on the desktop icon or from the "Start" bar select All Programs -> HandicapMaster7 -> "HandicapMaster 7".

   You will be presented with the Setup Interview Wizard.

   1. Click 'Next' and then select CONGU Unified Handicapping System and click 'Next'.
   2. Select Network Edition and click 'Next'.
   3. Complete the wizard, choosing the applicable settings.

4. Firewall configuration

   If you are running a firewall you may need to configure it to allow the SQL server to receive incoming requests. The following information should be provided to your firewall administrator.

   Please note: this assumes that the HandicapMaster Database is located under the first (default) SQL Server 2005 Express instance. If you have multiple instances the 'MSSQL.1' value below should be replaced with the appropriate instance.

   The program "\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN\sqlservr.exe" needs to be enabled in the firewall to allow incoming TCP requests on port 1433 (the default ) or the port configured in the step above.