These instructions are intended for those institutions that wish to install the ILLiad SQL Server, the ILLiad Web Server, and the File/Print server separately. Unless you wish to set up your system this way, please ignore this section. The ILLiad Server Setup program is designed for a single server installation of all ILLiad components, so there are several things you must do differently for a multiple server installation. The bulk of the setup in such a case takes place on the machine you have designated as the ILLiad Web Server.
Change the SQL Alias Manager on the Web Server to point to the SQL Server Machine
Important: For the ILLiad Web Server machine to perform the initial set up, as well as for daily use of the system, it must be allowed to access the ILLiad database on the SQL Server. The port used by SQL Server (port 1433 unless changed) MUST be open between the Web Server and SQL Server machines for the system to function.
From the machine designated as the ILLiad Web Server, open the SQL Alias Manager. Change the Server Name value from the local server to the IP address of the new SQL Server.
ILLiad Server Installation from the Web Server
Return to the Atlas Systems website at http://www.atlas-sys.com/ and download the latest version of the ILLiad Server Installation program:
You will need to contact Atlas Systems, Inc. for the location of the needed file.
- ILLiadServerInstallation.exe
Save the ILLiad Server Installation program to your desktop or to some other easily accessible location.
The ILLiad Server Installation Interface
When the download is complete, run the ILLiadServerInstallation.exe file. The ILLiad Server Installation program will appear.
Set Your Paths
Be sure that the paths specified in the top portion of the interface are the correct locations for your installation preferences and enter the correct IP address for the ILLiad web server in the appropriate field. You may need to change drive letters and/or paths from the default settings depending on your preferences and the complexity or your ILLiad Server setup. All path settings are from the point of view of the ILLiad Web server being installed EXCEPT the ILLiad Database Location. The ILLiad Database Location value should be set so that the specified path is correct from the perspective of the SQL Server. For example, if the value for this setting is the default: C:\ILLiadData, the location of the ILLData on the physical SQL Server machine should be C:\ILLiadData.
The BDE setting that was changed earlier in the setup process to point to the SQL Server machine will tell the ILLiad Server Installation program where to install the database.
| Web Page Directory | This is the folder to which the ILLiad web pages will be installed. This directory must be set executable through the IIS Internet Service Manager before the ILLiad web pages will function. |
|---|---|
| ILLiad Database Location | This is the folder on the SQL Server machine to which the ILLiad Database will be installed. |
| Setup Download Directory | This directory is used by setup to download current versions of the files needed as well as the scripts to create the ILLiad system. |
| ILLiad Database Backup | This directory is where the ILLiad Database backup is to be located. |
| Web/File Server IP Address | This should be the IP Address or DNS of the ILLiad Web/File Server. |
| ILLiad Database Name | This should be the name of the ILLiad database, usually ILLData. |
| Windows Scheduled Task Directory | This path is typically set to C:\Windows\Tasks\. |
Both the borrowing and lending DLL’s require the logon.txt file to exist in the same folder as the dll so it knows which DB username to connect with when running as a shared server.
The first line of the logon.txt file must contain the SQL Server username that the DLL should connect with and is all that is required to be in the file. A corresponding logon account in the DBC should exist with the same username. As an example, dbc that is shown below contains an account for WASHINGTON, so the logon.txt file would exist with the first line containing WASHINGTON. Any additional lines in the file are ignored.
Explanation of Field Values
Setup Options
Each of the Setup Options on the right is checked by default. You will need to install each of these items in order to have a fully functioning ILLiad server. Below is a listing of the various Setup Options and what they will do.
| Create Database? | This runs CreateDatabase.sql which creates the ILLData database used by ILLiad. |
|---|---|
| Create ILLiad User Account? | This runs CreateILLiadUserAccount.sql which creates the "illiad" user account which the Client and DLL use to login to the database. |
| Create Tables? | This runs CreateILLiadTables.sql which creates the ILLiad tables needed in the ILLData database. |
| Set Database Permissions? | Sets the permissions on tables for the "illiad" use account. |
| Import Seed Information? | This will import the default values for customizations. |
| Import Library Addresses? | This will import the default lender addresses. |
| Setup Database Backup to HD | This will set up an automatic backup of the database to the hard drive. |
| Install Scheduled Task Jobs | This will set up any required scheduled tasks, such as Electronic Delivery Cleanup. |
| Install Web Pages? | This will install the web pages and support files needed for the ILLiad Web Interface. |
| Install Client Files/Tools? | This will install the latest version of the ILLiad Client, Staff Manager, and Customization Manager |
When all your paths are set, start the ILLiad Server Setup Program. It will connect to the download server, download the current version of all the ILLiad system files into the Setup Download Directory, and set up your new ILLiad database.