Network Configuration

Configure Calibration Control to create and connect to a SQL Server

Use Calibration Control as a client/server program, with one centralized data source, using an existing MS SQL Server® on a dedicated computer to host the database. This will allow additional user workstations to access the database. The SQL Server capability requires an enterprise license (product keys beginning with AS10).

Network Configuration Wizard

If you are already using Calibration Control in MS Access mode, you can begin the SQL Server connection process by selecting the Network Configuration option from one of the Utilities menus.  Note that the Network Configuration option will only be visible if you are using a product key that begins with AS10 (enterprise license).  Contact Ape Software to upgrade from an AS09 if you need an AS10 key.

If you are installing your software with an AS10 product key, you will automatically be diverted to the following wizard after entering your key.  Upon reaching this screen, press the [Next] button to continue.

Select Installation Type

The Client option connects you to an existing Calibration Control database. Therefore, choose the Client option (below) if you already have a Calibration Control database setup on one of your internal SQL Servers.  Otherwise, choose the Server option to create your Calibration Control database for the first time on one of your internal SQL Servers.

Select Existing SQL Server

Either select from a list of available servers in the dropdown, or type the name of your own database in the Server Name field.  After a successful test of the database connection by pressing the [Test Connection] button, the [Next] button will become enabled and you can press it to move to the next step.

Install Database on Server

Pay attention to this WARNING if you selected Server in Select Installation Type step (two above).  If you already have an Ape Software database installed on your SQL Server and you continue, you will delete that database in favor of a fresh new Ape Software database with nothing but the original five sample records. Your database administrator can prevent this from happening accidently by limiting the SQL Server authority of the Calibration Control users.

Otherwise, if everything is OK, click the [Next] button to create or connect to your database.  Connecting to an existing database (selecting Client in the Select Installation Type) should be instant.  Creating a new Calibration Control database can take anywhere from 30 seconds to 2 minutes depending on the speed of computers involved and current network traffic.

And that's it! You will usually need to restart Calibration Control to continue.

Last updated: 6/13/2011

Compatibility: Calibration Control versions 5.5 to current