Skip to main content
CCH Software User Documentation

SQL database

Product Help Banner.png

 

Planning the installation

You may either install the software locally on each computer or install it on a central file server so that authorised users can access the software from a single location. Even if you plan to install the software on a server, we recommend that you initially install it locally with a local database to familiarise yourself with the software before proceeding with the server installation.

Local installations - If you opt for a local installation, then you can have a local database to hold your data or set the system to access a network database. You can also have both a local database and a network database if you wish.
Network database - If you store your checklists in a database held on a network server, the checklists will be accessible from any computer on the network.
Local database
If you have a local database, the checklists it contains will only be accessible when you are logged onto your computer and you will be able to use the software out of the office. As indicated, you may have both a local and network database and we provide options for you to backup individual checklists that you have completed locally and restore them to your network database.
Network installation - Opting for a network installation means that you will only have to install the software once, on the network, and all users will run the software from the file server. The benefit of this is that you will have access to the software from any workstation and in future you will only need to install software updates once. With a network installation it would not be logical to have a local database, all users would access the data from a network server.
Both local and network installations - It is also possible to have a mixture of both network and local installations, maybe with a local installation on one or two computers that you may wish to take out of the office to use, and with other users running the software from the network.

SQL Database

The software stores its data in a SQL database and, as indicated, this can either be a database stored on a network server or you can have a local instance of SQL on your computer to host the data. By default, the routines will install a local instance of Microsoft SQL Server Express 2014 and create a local database for you. If you do not wish to install SQL remove the tick by the option during the installation process.

Note: the system requires SQL Server 2014 or above. Earlier version of SQL Server is not supported.
If you carry out a local install of the software and SQL, the routines will create a local database for you and set the software up to make use of this.
If you carry out a network installation, or a local installation without SQL, when you first run the software you will need to create a database to hold your data and details of how to do this are set out in a later section.

Licencing
The maximum number of users who may be set up to access the software is governed by your licence. Hence, if you have a 10-user licence then only 10 users may appear in the user list. If you reach you licence limit, then please contact your account manager to obtain the right to add additional users.

Downloading and extracting the installation files
• Access the CCH Interactive Checklist download page on the CCH software supportwebsite.
• Create a temporary folder to hold the downloaded file, assumed to be C:\TEMP in the following instructions.
• Locate and click the Download button to download the update installer file into the previously created temporary folder C:\TEMP. The downloaded file is called CCH Interactive Checklist_Full_Installation V1.ZIP.

Installation (local)

The following instructions are for carrying out a local installation on your computer. Please refer to the separate server installation instructions if you are going to carry out a server installation.
.Net Framework 4.0
CCH IC requires the Client Profile subset of the .Net framework 4.0 to be installed on your computer. If you do not have this, or the full version of .Net 4.0 installed, it will be installed for you.
SQL Server Express 2014
By default, the routines will install SQL Server Express 2014 and set up a local database to hold your checklist data. If you do not want it to do this, for example if you already have SQL server installed, you may remove the tick by this option. If you remove the tick, then you will need to create a new connection and database as described later in these instructions.

Note: that by leaving the option to install SQL ticked you are agreeing to the Microsoft standard Terms and Conditions for the use of SQL Server Express 2014.

Note: .Net Framework 3.5
SQL Server Express 2014 requires .Net 3.5 to be installed. If this is not present the installation of SQL will silently fail, and you will get a message that SQLCMD cannot be found. If this happens please install .Net 3.5 and re run the installation of CCH Interactive Checklist.

Installing the software

Note: Depending on your hardware and the options that are installed, the installation process can take from 5 to 30 minutes.

To install the software, run CCH Interactive Checklist Full installation V1.exe by selecting the downloaded ZIP file in C:\Temp and double clicking on the EXE file in Windows explorer.

ic1.png

If you are presented with a User Access Control dialog, click on Yes. You will be presented with a series of dialogs as follows:

clipboard_e6a39ba1ce2d8b6b2dbf2826278ee171f.png

clipboard_e9df8080132cf3577435c7b4885acbb41.png

Note:The default directory in which the software will be installed on your local computer is C:\Program Files\CCH ProSystem\Interactive Checklist for 32 bit operating systems and, C:\Program Files (x86)\CCH ProSystem\Interactive Checklist for 64 bit systems.

clipboard_e62bcfcde3545d8f3f5fd9d6df5ccbd86.png

clipboard_e108184bfefa95bfe278a13591ccc64a6.png

clipboard_ec5f505d03d2bd08813d9208c489d6d41.png

clipboard_e1b43c6994d28b748391ec39273ef2515.png

Installation of the .Net Framework (if option ticked above)
If this option was not ticked, then please skip to the next section on installing SQL Server Express.
If the .Net framework was selected, the following dialogs will appear. The process will vary depending on the operating system you are using but will be similar to the following which is for Windows 7.

clipboard_e4ce68e957412f083bcbbff4cef9832e2.png

clipboard_eba43f22b69a51f1c88ccc2864dcc5f28.png

clipboard_ecb60b8bd53a026befc7ee6a8ca0ca834.png

Installation Progress
The installation of SQL Server and CCH Interactive checklist will proceed without further user intervention and you will see a series of dialogs and progress bars appear as this happens.

SQL Server Express
If this option was ticked, you will the following dialog for several minutes.

clipboard_e3aa0d62b568916a8312da8e2a3d26fa3.png

You do not need to take any action, the dialogs will automatically close when the installation of SQL is complete.
The last action is for the system to install the CCH Interactive Checklist software and the latest versions of the checklists. During which the following dialog will be the only one shown on the screen:

clipboard_e867b04e527aca1d8269350911dca2192.png
On completion, the will display the Installation Complete message:

clipboard_e2dc52ad702a726192d1e607d76503326.png

Launching the software
You can launch the software using one of the shortcuts provided:

 

clipboard_e79b3c9e73e1d9cbb31ba6d526d0ead40.png

Support
If you are experiencing difficulty and need assistance with installing the software, please contact our software support team via phone on 0344 561 8181.

Quick Start Guide
If you did not leave the option to install SQL Express ticked, you will need to manually create a connection and database. Please refer to the Appendix 1 for details of how to do this. The following assumes that you left the option to install SQL ticked and hence created a local database.
On loading the software, you will be presented with the Login dialog with the available connections listed. Initially this will show the connection to the checklists stored in your local database.

clipboard_e133e0c4c7f9c3853142194080de572c5.png

 

clipboard_e6fa9bd7acdd652f9ebbc52af5c13a88b.png

Creating your first client

clipboard_e39be9f3bed83a3ff0d45d2418bb1e5c5.png

Note: the lead partner and office entries are optional, however completing them will make it easier to find clients later on.

The client will appear in the client list displayed in the top grid:

clipboard_e1e45a286a8036980fd6bcec27244d05b.png

Enter the name of the client, the lead partner and office and click OK.
To add a new client, select Add client from the Client management ribbon bar.

Creating your first checklist
Select the client by clicking on the name in the top grid and the Add checklist option in the dividing toolbar will become active.

clipboard_e5b874fb1187c4315fb2952d9fd039264.png
The Add checklist dialog will appear and as this is the first checklist created for a client, the Select group field will be blank and the period start dates will both be set to the current date.

clipboard_efb41d39e8c3c6f817aae0b0eb9f0d324.png
1. Select the type of checklist to be created from the Select group drop-down list. The checklist will be created and loaded for completion.

clipboard_ee8d7b4b5c9bf541cda89a303fc6d9642.png

Click on Tailoring questions in the navigation area on the left to load and display the contents of the checklist on the right.

clipboard_e1a026c06798851212cd4c5b2c3c6c6f7.png

Click on a row in the checklist to move focus to the completion area and you can then navigate through the checklist using the up and down arrow keys and answer questions using the keyboard shortcuts shown in the answer panel that appears at the foot of the window.

clipboard_ec7d4a1464d1abe379f4f63d4314db47d.png

Please refer to the user guide for more information about managing and completing checklists.

To close a checklist and return to the Client management display, select Close checklist from the ribbon bar: The Client management window will be displayed with the details of the new checklist created shown in the lower panel.

clipboard_e56c341d88008cc3944c2f7af8ed53086.png

Double click on the name of the checklist to return to the Checklist completion window.

User guide
Full details of how to use the system and the functionality that it provides are contained in the user guide that can be downloaded from the website and is also available from the User Guide
option on the ribbon bar.

clipboard_edcf3ebc9d368e4dead993b2fb74e859f.png
We strongly recommend that you read the user guide in full to ensure that you get the most from this new system.

Appendix 1 : Creating a connection and database

If you did not install SQL Express, you will need to manually create a connection and database the first time that you launch CCH Interactive Checklist. This can either be created on a network server so that all users have access to the same data, or you can create a local database if you have Microsoft SQL Server Express installed on your computer.
On launching the software, you will be presented with the Login dialog:

clipboard_e591bcd9e8fccc0c0fd858437f929ecf7.png

We recommend that you name the database “Checklist” so that it is easily identifiable by our support team should you need to seek assistance. The following
example will create a database called Checklist in the local instance of SQL Express:

clipboard_e7bde641d488db101df99721afb75c5e7.png

Note that you will not be able to use the Test button as the database has not yet been created. Click OK and the systems will display the following question:
clipboard_e35fd26be49930490074e7d0acfb67c98.png
Note: If you see the following message when you try and create a new database or login it probably means that you do not have Mixed Authentication selected for your SQL instance.

clipboard_e74c12834b067b6adc2ba89844408b00e.png

Please refer to Appendix 2 for how to change this setting. Click on Yes and the connection and database will be created.

On returning to the Login dialog, the available connection will be listed:

clipboard_e8fc209ace0b8787d26614d91db12f263.png

Appendix 2 – Changing the access mode for SQL Server

CCH Interactive checklist requires the SQL server to be set for Mixed Mode access. If it is not set to this then you will see the following message when you try and log into the software:
clipboard_e1bb8c3629dc771372093acdfc4b8ed70.png
If you see this message, you can check and change the access mode using SQL Server Management Studio as set out below.
If you do not have Management Studio installed, you can download this free of charge from the Microsoft website:
Link to download for Management Studio Express for SQL 2014

Checking and changing the access mode

Launch SQL Server Management Studio from the start menu

clipboard_eb4437e3785bcf0d407c24de7087e8a1a.png

 

clipboard_e8df9cab3280e615428825afceed563e0.png

If you have changed the mode, you will see the following message:

clipboard_e88581e798ac00b4a6b975b67b4803204.png
You will need to restart the server for the change to become active and the easiest way to do this is to close down and restart the computer.

 

  • Was this article helpful?