System Database Setup
After installing TRAVERSE Server, the first thing you must set up is the System (SYS) database. The SYS database contains information about TRAVERSE companies, security, menus, user settings, currency, exchange rates, and language.
To setup the SYS database, follow these steps:
-
Log in to TRAVERSE Server Manager.
-
Expand TRAVERSE in the left column. The word Install... then appears below it.
-
Click Install.... The Install System Database dialog box appears.
The Name and Description fields are unavailable.
-
When creating the System database, you should estimate how big it will be when filled with data. If the initial size that appears in the Initial Size box is not large enough for what your database requires, change the number. Once created, the database size automatically grows as you add information. To change how the database grows (whether it be by megabytes or by percentages), use Microsoft SQL Server Enterprise Manager. Microsoft SQL Server Enterprise Manager is installed with Microsoft SQL Server.
-
The Template Folder box displays the default path where the Server Manager template file is installed. Should you need to locate the Template.tsm file, use the Browse button to search for the file.
-
Click OK. The Status tab appears and displays Server Manager’s progress as it creates tables, views (queries for tables), and stored procedures for the SYS database.
-
When finished, Completed displays on the Status tab and the following message box appears: “TRAVERSE System Database created. Refer to log for any messages.” Click OK.
-
Click Close to exit the Install System Database dialog box and return to the Server Manager main window.
-
If you purchased the Payroll application, Server Manager prompts you to set up the Payroll (ST) database.
If you are not using Payroll, Server Manager prompts you to set up a sample company (CPU by default).