Add Ape Database to SQL Server

Install Calibration Control on a SQL Server

Before beginning, ensure you are signed into a SQL Server with enough permissions to create and update databases and their objects (e.g., system admin).

Installing the apecal database on an existing SQL Server (2012 or higher) is a simple database restore from a provided backed up file.  All SQL files needed to perform the install reside in the SQL Tools folder under the CC program folder located at Program Files (x86)\Ape Software\Calibration Control.

There are two backup files (.bak) located in the SQL Tools folder. One is the sample database named apecal_sample_{structure/records versions}.bak (i.e. apecal_sample_s84_r86.bak) and the other is a blank database named apecal_{structure/records versions}.bak (i.e. apecal_s84_r86.bak). Copy the backup file you wish to restore to your SQL Server default backup location.

Restore Back-Up Database

Follow along with our Backup and Restore SQL Server Database help topic for more detailed instructions. From within SQL Server Management Studio with the SQL Server connected, right-click on the Database node and select 'Restore Database'.

Enterprise Manager

From within the Restore Database dialog, type the name apecal in the 'Destination' field, select 'Device' as the Source, and then click on the [. . .] button to the right of the ‘Device’ field.

Restore apecal SQL database

From within the Specify Backup dialog, click the [Add] button.

Locate the backup file by navigating to or pasting in the 'Selected path'.  Paste or type the name of the file to restore from (e.g., apecal_s51_r52.bak).  Then click [OK] to save and close the backup file and [OK] again to close the Specify Backup dialog.

Locate Database Backup File

When the Restore Database dialog is on the top again, click the checkbox in the Restore column of the backup set (file) you just designated and then click the [OK] button to begin the restore.

If successful, the following confirmation dialog should display:

Successful Database Restore

After closing the confirmation dialog, refresh the list of databases to see the new apecal database.

Restore Failed

If the restore failed, you may need to repeat the above steps and specify different file names or path statements.  Use the Options Page of the Restore Database dialog to modify the Database (e.g., Rows Data) or Log file names or the Path statement (i.e., Restore As).

Restore Database Options

User Security

Users can connect to the apecal SQL Server database using either Windows or SQL Server authentication.  Each user will either need Database Roles or Explicit Permissions.

When using Database Roles, ensure each user has db_datareader and db_datawriter roles.

SQL Server Database Roles

When using Explicit SQL Server Permissions, ensure each user is granted at least the Connect, Delete, Execute, Insert, Select, and Update permissions.

SQL Server Database Roles

If you need help, contact Ape and we can setup a screen share and do this together.

Last Updated:  27 October 2020