Control Error - No Names in Login User Dropdown
Error Message
None
Explanation of Error
The login screen for Control contains a UserName dropdown with a list of all the valid users set to login to Control. The list of names is retrieved from the SSLIP, but the list is empty. (If the SSLIP communication was not successful a different message would be displayed.)
Severity
High. The user cannot login.
Possible Root Cause(s)
- The list of names is retrieved by the SSLIP when it connects to the database. The failure to find the names is a sign that the SSLIP was not able to connect to the database.
Resolution
- Restart the SSLIP. Check if the Control login has user names in the dropdown.
- Check the Connection between the SSLIP and Database
- Login to the SSLIP.
- Open the database administrator and navigate to the Control StoreData Database.
- Test the database connection.
- If the connection test fails, see SSLIP Error - Unable to Connect to the Database.
- Check the User Table.
- Login to the SSLIP.
- Open Database Browser for the Control StoreData Database.
- Open the User Table
- Verify that there are logins in the system. It is not possible to delete the administrative login from within Control.
- If there are no logins, you will have to manually recreate the administator's entry in this table. Open another valid database and manually copy the values in the administrator user login (ParentID = 10).
Related Errors
You could leave a comment if you were logged in.