Skip to main content

ISO Service Unable to Connect to Database After ILLiad 9.1/9.2 Update

ProductILLiad
Version9.1/9.2
TicketN/A
KB PermissionsPublic

Purpose​

Institutions whose SQL servers use both named instances and nonstandard ports may find that their ISO Service is no longer able to connect to the database after updating to ILLiad 9.1/9.2 due to a known issue affecting how the service parses the system's default DBC file. If you are experiencing this connection issue after your 9.1/9.2 update, please follow the steps in this article to implement the recommended workaround.

Procedure​

To implement the workaround for this issue, please create a copy of your default DBC file in the ISO Directory following the steps below:

  1. Locate the default DBC file on your ILLiad Server and create a copy of this file in your ILLiad ISO Directory (default path C:\ILLiad\ISO).
danger

The copy of the DBC file mustbe namedlogon.dbc.

  1. In SQL Alias Manager, click Openand navigate to your ISO Directory to open the copied DBC file.
  2. Reformat the value in the Server field from <servername>&lt;instancename>,<portnumber> to <servername>&lt;instancename>:<portnumber> (i.e. replace the comma with a colon).
  3. Click Save.
danger

Please ensure that you do NOT set this copy as the default DBC file for the server - it is just a copy used solely for the ISO Service.