Connect to SQL Server Database

Configure Calibration Control to Connect to a SQL Server

After creating the Calibration Control database on your SQL Server, follow these instructions to connect Calibration Control (our Calibration Management Software) to that SQL database.

Start Configuration Wizard

Start the Network Configuration Wizard when running Ape software for the first time and selecting [MS SQL Server] as the default database type.

Choose Database Format

. . . then click [Yes] . . .

MS SQL Server Not Identified

. . . or, if already connected to an MS Access database, select the 'SQL Connect' option from the Utilities tab in the ribbon menu.

Connect to SQL Server

Either method (above) displays the following dialog.  Click the [Next] button . . .

SQL Server Connect Wizard

Enter the fully qualified name into the Server Name field, confirm the database name, and click the [Test Connection] button to confirm that you have entered the correct connection information.  When successful, the [Next] button will enable.

Select SQL Server

Then click the [Launch] button . . .

SQL Server Connection Wizard Finished

to SQL Server

After entering the correct connection settings, Calibration Control will restart and you will be required to provide SQL Server sign-in credentials.

SQL Server Sign-In

Contact Ape if you need help.

Restarting the Process

This entire process (above) creates a config file in the Settings folder on the computer where the Ape software application is running.  Therefore, if a mistake is made during the process the best way to restart from scratch is to delete the config file and begin again.  Do this by . . .

  1. Closing the Ape Software application
  2. Opening the Settings folder, which is usually found at: C:\Users\Public\Documents\Ape Software\Calibration Control
  3. Delete the general.config file (or, for advanced users, whatever config file required)
  4. Re-start at the top of this page

Connection Troubleshooting

If needed, refer to the help topic on Troubleshooting a SQL Server Connection.

Last Updated:  27 June 2019