1. Knowledge Link
  2. Estimating Link
  3. Estimating Link Pro - Network

Estimating Link Server Configuration Tool

What is it and what it does

Purpose

The Sever Configuration Tool was developed to assist in the installation of Microsoft’s SQL Server and database on a Server Operating System to allow for the Estimating Link program on a network workstation to communicate with the SQL Database.

Primary Function

To install the SQL Server, create a database and add the requirement necessary for the communication between the Network server and the workstations on the network providing a multi-user environment. Also to schedule daily backups of the attached database.

Secondary Functions

  • Manage Users: Allows for the viewing of what users are using a database.
  • Connected Users: Allows for disconnecting users from the database.
  • Get or delete a server key.
  • Create Database: Allows for multiple databases to be created on a SQL Server instance.
  • Backup Database: Allows for backup of a current database.
  • Re-Index Database: Allow the user to re-index a database.

Database Tools

  • Rollback Database: Allows for a rollback to a prior database version.
  • Set Database to Muti-User: Allows change from a Single User database to a Multi-User database.
  • Update Database Statistics: Updates the index to queries used in accessing a database.
  • View/Change Database Location: Allows the user to change where periodic backups of the database are stored.
  • Restore Database: Allow for restoring a database backup on an SQL instance.