Setting up GainSeeker on a SQL Server database

Your SQL Server database administrator (DBA) must perform the following steps on the SQL Server:

1. Create a new GainSeeker database. Two variations of the example script for creating the database and tables, SPC8_SS.SQL, are provided in the \Scripts\SQLSVR\ and \Scripts\SQLSVR\Expanded\ folders on the GainSeeker installation CD, but both use the same SQL statements to create the database.

You may choose either a case insensitive (recommended) or a case sensitive Collate option for the new database. When using the case sensitive option, all table names and field names will also be case sensitive.

2. If using SQL Server authentication (recommended), create a User for this GainSeeker database. For this new user:

   1. Set the Default Database to the GainSeeker database.

   2. For the GainSeeker database, grant the roles of public and db_owner to this user.

3. Create all necessary tables in the GainSeeker database. Scripts for creating and populating the necessary tables are provided on the GainSeeker installation CD:

   • If you plan to use the typical GainSeeker table structures, use the SPC8_SS.SQL script in the \Scripts\SQLSVR\ folder.

   • If you plan to use Expanded data fields, use the SPC8_SS.SQL script in the \Scripts\SQLSVR\Expanded\ folder and update the variables @DBPSD, @DBPD, and @DBUDL to the desired field lengths.

4. Ensure that statistics will be updated regularly for this database.

After setting up the database, you can install the GainSeeker client on each workstation.

• The first GainSeeker client installation will prompt you to enter the SQL Server name, choose Windows Authentication or SQL Server Authentication, specify the SQL Server Login ID and Password (if using SQL Server Authentication), and choose the name of the GainSeeker database (catalog).

• If you used the script for expanded data fields, you must use the GainSeeker System Administration module to set the field lengths for the Initial Configuration:

• 1. Go to the settings for Tables and File Paths and click the Expand button. This will display the Expand Column Lengths window with default column lengths.

  2. Set the three column lengths to match the three variables in the script you executed, then click OK.