Why is Everest not recognizing passwords?

Overview

Everest has not recognized passwords for users, EDI, and the eCommerce system. Rebooting the server temporarily solves the issue. When the issue manifests, all orders from the EDI and eCommerce systems fail, saying "password incorrect".

Solution

To solve this please follow the steps below:

1. Log in to SQL Management Studio.
2. Clear any stuck sessions from the EVEREST_SPM table.
   1. Expand the Database node and right-click on the EVEREST_SYSTEM database.
   2. Select New Query

   3. Execute the following query:

      use EVEREST_SYSTEM; 
      delete from EVEREST_SPM;

      Note

      After the query completes successfully, you will receive a confirmation message saying x rows affected. This indicates how many entries on the EVEREST_SPM table have been cleared.

3. Ensure a larger number of simultaneous connections:

   1. In Object Explorer, right-click the server and click Properties.

   2. Click the Connections node.

   3. Under Connections, in the Max number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect simultaneously to the instance of SQL Server.

      Note

      Use 0 to signal unlimited simultaneous connections.

   4. Restart the SQL Server.

If clearing the EVEREST_SPM table resolved the issue, please make sure that users log out of Everest properly to avoid this from happening again.

Testing

After applying the above steps, Everest should recognize passwords and allow normal operation. In case the issue reoccurs, please get in touch with support, so we can investigate deeper into the issue, and take further action if needed.