Skip to main content
CCH Software User Documentation

Appendix 1: Changing the Access mode for SQL Server

Product Help Banner.png

 

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

 

 

  • Was this article helpful?