Server Manager Overview
TRAVERSE is enterprise software with a distributed file structure. Data, setup programs, and source code are stored on the server, while the programs, library, and help are stored on each client. In addition to its own components, TRAVERSE requires Microsoft SQL Server on the server side as a backend database and Access on each client to support the user interface. If you purchase the TRAVERSE Business Edition, you can also use the SQL Server Desktop edition (also called MSDE).
TRAVERSE Server Manager enables you to perform necessary tasks on the server side of TRAVERSE. Using Server Manager you can create new companies, import or export company data, delete companies, update server components stored in Microsoft SQL Server, configure group and user security, set company permissions, and add or delete payroll years.
Note: You must have sysadmin rights to use the functions within Server Manager.
Server Manager Online Help provides the following functions for customizing, setting up, and maintaining your TRAVERSE system:
|
Covers the system requirements for TRAVERSE Server Manager as well as the required steps for installing TRAVERSE Server Manager. |
|
|
Describes the required steps for setting up the System Database (SYS) and the Payroll (ST) Database. |
|
|
Covers the database creation (including the ST database) and maintenance functions such as how to add a new company database, copy data from an existing company database, and backup a database. Also includes the steps for viewing database properties, attaching, detaching, deleting, and restoring databases, how to add and remove applications from a database, and how to generate scripts from the objects within an existing database. Adding payroll years to company databases is also included in this section. |
|
|
Describes how to create logins, change login properties, and how to delete a login. This chapter also covers how to copy security information from one company to another as well as how to define group and user access to TRAVERSE data and the functionality groups and users will have within the system. Steps for defining permissions for groups and users within specific databases are also included. |
|
|
Covers the required steps for performing TRAVERSE maintenance updates and for updating Product IDs. Also covers the procedure for updating index statistics when you have made a significant change in the key values in the index, added, changed, or removed a large amount of data in an indexed column, or truncated the table using TRUNCATE TABLE and then repopulated it. |
|
|
Covers the required steps for generating user and error logs. |
|
|
Describes how to migrate your existing TRAVERSE data into TRAVERSE 10x databases use the TRAVERSE Data Migration Wizard. Also describes the process for executing DTS packages. |
|
|
Covers the required steps for installing TRAVERSE Client. |