Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: First published version


Zen Section

Creating a New Database Connection

Each computer that will be using the ILLiad Client will need the SQL Alias Manager (SAM) installed and configured in order for ILLiad to work. The SAM will be installed by default when installing the ILLiad Client and a shortcut will display on the desktop.


You will likely need to right click on the SQL Alias Manger icon and select Run as Administrator to complete the configuration steps below.

  1. Right click on the SQL Alias Manager icon and select Run as Administrator.
  2. Click the New button on the ribbon interface. A menu will appear.
  3. Click ILLiad to create a new profile for ILLiad.
  4. In the middle Database Connection column, fill in your ILLiad server address.
  5. Fill in your ILLiadDatabase name. The default is ILLiadData.
  6. Leave the Connect Timeout checkbox blank. This will be populated with the default values when the profile is saved. Also leave the Username and Password fields blank unless instructed otherwise by your database administrator.
  7. If your SQL server supports SSL, you can check the Secure box. This will encrypt the connection to the SQL server.
  8. Click Save to save the profile alias. Atlas recommends saving the file as logon.dbc ( in the folder where the client program files are saved. The default is C:\Program Files(x86)\ILLiad\logon.dbc).
  9. After saving the alias, click the Set Default button to set that alias as the default alias to use on that computer.