Installing the database

NOTE: Before you can proceed with installing the database please ensure you have already installed the SQL Server database engine along with the tool called SQL Server Management Studio Express) and configured it for use (see GUIDE 1).

Begin by launching the LADS Plus Administration module:


The file is will be found in the LADS Plus Network folder, which you chose during installation (see Chapter 2).

After launching the executable you should be presented with the Lucid Database Installer Tool (below).

You need to choose the SQL Server Name (including instance name after the backslash if appropriate) and the ODBC driver.

If using SQL Server 2008 choose the driver: SQL Server Native Client 10.0

If using SQL Server 2005 choose the driver: SQL Native Client

If you wish to use Windows Authentication for SQL Server, choose that option (see the example picture below).

If using SQL Server (Mixed Mode) Authentication please have the ‘sa’ administrator account password available as you will need to enter it. Then click Install to proceed.

Any feedback during installation will be shown in the text window. If the database has been installed already, the tool will detect this and leave it alone, simply creating the connection string file if necessary. Click Finish and then re-launch the LADS Plus Admin application.

If you think you may have incorrectly configured the Database Installer Tool, for instance, you get long error messages when running the LADS Plus Admin module, you can start again by manually deleting the file server_configuration.dat in the folder called \Data which is a child of the application folder. This file contains an encrypted connection string used by the software to connect to the Lucid database. Then run LADS Plus Admin application again and this will launch the database tool again.