Configuring the Workstations (MS SQL Server)

1.  Select Start ► Programs ► Abbott Jewelry Systems ► Administrative ► Configure The Edge to open the Configuration window.

2.  Find the section labeled Database Settings.  This is where you will specify the locations of the database file. 

There are two sets of database settings:  Production and Test:

•      Production is for standard day-to-day operations.

•      Test is useful for training and other non-production situations.  When Test mode is in operation, a large watermark will appear on your screen. 

3.  From the Database Settings area, Production Settings line, select the browse dots. 

4.  The Database Configuration window will appear.

5.  From the Database Type drop-down menu, select MS SQL Server.  The Production Database Settings window for SQL will appear.

6.  Complete the fields as described below:

a.  Database Type:  Keep MS SQL Server.

b.  SQL Server:  Locate the SQL Server instance using the drop-down menu.

c.  User Name:  Enter sa (case sensitive) unless instructed otherwise.

d.  Password:  Enter your SQL server password provided by Edge Technical Support during your SQL installation. If you have forgotten your password, contact Edge Technical Support.

e.  Database:  Select the database name from the Database drop-down menu.  The default is EdgeSQL.

f.   Shared Folder:    This is the shared folder on your server used for database files and photo.  Enter the path (e.g., \\servername\sharefolder\) or click directly on the DatabasePath line and browse for it.  This should be the path to the database folder created and shared on the server during server configuration.  If you are unsure of the shared folder, check this setting on another Edge workstation that is running SQL Server.

g.  Photo Path:  The PhotoPath refers to a folder that will hold all of your images for The Edge.  It is strongly recommended you keep this in the same location as your database.  By default, The Edge creates a photos folder with sample images in the default data path.  Type in the path to the photo folder (e.g., \\servername\sharefolder\photos) or click directly on the PhotoPath line and use this button to browse for it.  This should be the path to the photo folder created and shared on the server during server configuration.

h.  Memorized Report PDF Report Path:  Contains the location where PDFs of memorized reports will be saved.  Keep the default unless instructed otherwise.

7.  Use the Test Connection button to test access to the specified SQL Server folder, user name, and password.

8.  Select OK twice to return to The Edge Configuration screen.

9.  Find the section labeled Station ID.

10. Change the StationNumber to the next available consecutive number.  Remember that your license defines how many workstations can access The Edge. 

11. Enter the appropriate store number.

12. Select OK to save your changes.