Skip to main content
OCLC Support

I am getting an SQL "Named Pipes Provider" error when trying to open ILLiad programs

  1. Last updated
  2. Save as PDF
Symptom
  • I am getting an SQL "Named Pipes Provider" Error when trying to open ILLiad programs like Billing Manager.
Applies to
  • ILLiad
Resolution
  1. Open the Atlas SQL Alias Manager
  2. Click on the ILLiad logon (machine default)
  3. In the lower-left portion of the SQL Alias Manager screen displays the path to the .dbc file. Make sure the Default logon is pointing to c:\program files ( x86)\ILLiad and double-click on the Logon.dbc (or whatever name you called your .dbc file)
  4. In the SQL Alias Manager, if the Server field contains an IP address, replace it with the SQL VIP Server URL (e.g. xyz-db.illiad.oclc.org).
  5. Also, be sure that traffic is allowed in and out of the library's network for the hosted database URL/domain (e.g. xyz-db.illiad.oclc.org) on ports 1433 and 1344.
  6. Make sure the correct permissions for the ILLiad folder are in place. See how to do that here.
  7. If more than one login profile is showing, delete any that aren't pointing to c:\program files ( x86)\ILLiad, close the SQL Alias Manager, and then double-click on the Logon.dbc (or whatever name you called your .dbc file). You may need to look in other places on the computer, as even a stray .dbc can attach itself to the SQL Alias Manager.
  8. If a database connection or .dbc is pointing to another folder, go to that incorrect directory and delete it.
  9. Open the program again to see if it works. If it does not, follow these steps to correct connectivity issues.
  10. If the problem persists, contact OCLC Support. 
Page ID
32425