In the ILLiad 9.0 Release Notes, there is a section in the Important Update information that says:
"All patron users with ILLiad auth types of ILLiad, ILLiadExclusive, or PatronAPI will be required to reset their password upon the first login after ILLiad 9 update. This does not affect RemoteAuth or LDAP users."
You should check your Patron accounts under the AuthType field in the User records if you are using RemoteAuth or LDAP authentication. If your patron has an AuthType of ILLiad, they will be required to log on even after logging in with RemoteAuth or LDAP authentication. You should update any patron who is only to use RemoteAuth Authentication or LDAP authentication to have the AuthType of Default. You can do this in two ways:
1. Go to the patron record and deselect the ILLiad Authentication box.
2. Have your SQL Administrator update the patron records by changing the AuthType from ILLiad to Default. If you wanted all the patrons to have the AuthType of ILLiad, you could run this query for a
A. single server:
B. On a Shared server, you would have to consider if you want the update to be on all sites or just one of the sites.
1. If you have two sites of ABC and CBS and you want them all to be updated, then the query would be:
2. If you just wanted the Site ABC to be updated, then you would change the query to: