Installing the eLab Database

At each step of the installation , if there are any advanced options available, these can be accessed by clicking t he Show advanced options button at the top of the page.

To install the eLab database for the first time, follow these steps:

To begin installation download and run eDBA from the www.ebiosys.com.
On the End User License Agreement page, read the license agreement and if you agree click Accept.
On the Overview screen click Next.
On the Options page, click Install a new instance of SQL Server and a new eLab database.
Specify a SQL Server name, or the default name of ‘eLab’ will be used. We recommend you use the default name.
Click Next. The Database details page is displayed.

Figure 40.1. The Database wizard - Database details screen.
Enter a descriptive name for the installation of the eLab database in the Database name box. It is recommended that you use the default name ‘eLab’.
If you have purchased a Sample License from the eBioSys website (www.eBioSys.com) select the License key option and enter the key. Otherwise, ensure the No key (trial version) option is selected, if you use this option you can specify a license key later from within eLab.
In the FDA 21 CFR Part 11 Compliance section you will need to select the level of compliance for the system. If you are not required to install an FDA compliant system, or if you have other processes in place that ensure your compliance, significant resources can be released helping to improve the performance of the system. See the FDA guidelines for more information.
- Select Enforce compliance to install a system that complies with the FDA guidelines.
- Select Allow non-compliance with warnings to install a system that allows non-compliance with the FDA regulations, but prompts the user with warnings.
- Select non-compliance to install a system that does not prompt the use if a setting is changed that may affect compliance with the FDA guidelines.
If you decide to allow non-compliance with the FDA regulations the Database settings section allows you to specify which aspects of the system will and will not be compliant. Disabling options can release significant resources and help to improve the performance of the system. See Database Settings for a discussion on these options.

Advanced Options: The advanced options of this page allow you to specify the locations of the database files and details of the outgoing mail server. The available options are:
- Database directory. The directory specified by this option determines the location of the data file for SQL Server.
- Database script. The directory specified by this option determines the location of the script file that is run once SQL Server setup is complete. Only modify this option if you are given a script file and instructions from eBioSys.
- Library deployment directory. The directory specified by this option determines the location of the dll file used by SQL Server
- Outgoing mail server. This option is used to redirect the way that email notifications are sent to eBioSys.
Click Next.

Figure 40.2. Database wizard - Account details screen.
On the Database administrators account page complete the required details for the system administrator’s account. Click Next.

Advanced Options: The advanced options of this page allow you to set the details of the administrators account such as:
1. The period of time since the last activity that the account remains active for.
2. If the user is required to change the password on the next login.
3. How often the account’s password needs to be changed.
4. The period of time that the account is valid from and until.
5. Whether login information can be saved between sessions and if accounts allow auto login.
Note: It is recommended that you maintain the default name for the administrator account and administration group.
Confirm the details of the Summary page and then click Next.
Note:
- The wizard will then launch the SQL Server setup application.
- If prompted, you must authorize the launch of the SQL Server Express setup application.
The processing page is displayed as after SQL Server set has completed the wizard will then create the eLab database and secure it. After processing is complete, click Close to close the wizard.
If you have a firewall installed and enabled, you may need to modify your settings to allow File and Printer Sharing and open UDP port 1434. This will allow eLab applications installed on other computers to access the database.
- Click the Windows Start button, and then click Control Panel.
- For Windows XP and Windows 2003: If the Control Panel is set to Category View, double click Security Center, and then click Firewall. If the Control Panel is set to Classical View, then double click Windows Firewall.
  For Windows Vista: If the Control Panel is not displaying the home page, then click Control Panel Home. Click Allow a program through Windows Firewall under the Security category. If the User Account Control dialog box appears, grant the right to open the Windows Firewall.
- Click on the Exceptions tab and click Add port...
- In the Name box, type "SQL Browser Port"; in the Port number box, type 1434; and select the UDP protocol.
- Click OK to add the program, and then click OK to close Windows Firewall.

Note:

See the Getting Started guide on the inside of the front cover for order of processes involved in getting an installation of eLab up and running.
If Microsoft .NET 2.0, Microsoft Data Access Components 2.8 and Crystal Reports 2.0 is not installed, you will asked to accept the relevant EULAs, after which they will automatically download and install. If Microsoft .NET 2.0 is not installed you will be required to reboot your system. After all pre-requisites have been installed the installation will continue automatically. If it does not, return to the website and click on the Download button again.
When installing a new instance of SQL Server using eDBA on Microsoft Windows Vista, you may be prompted to grant administrator rights to the SQL Server setup program, part way through the process. You must grant these rights within 120 seconds otherwise installation will fail. If this occurs, Click on the Retry button in the wizard, or run the wizard again.