ISO Service Unable to Connect to Database After ILLiad 9.1/9.2 Update
| Product | ILLiad |
|---|---|
| Version | 9.1/9.2 |
| Ticket | N/A |
| KB Permissions | Public |
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:
- 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 must be named logon.dbc.
- In SQL Alias Manager, click Open and navigate to your ISO Directory to open the copied DBC file.
- Reformat the value in the Server field from
<instancename>, to<instancename>: (i.e. replace the comma with a colon). - 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.