Database connection failed: Login failed for user 'cyrious'. The user is not associated with a trusted SQL Server connection.

All connections from Cyrious Control and the SSLIP log into SQL using a SQL user called “cyrious”. This message is telling you that the cyrious user is not part of SQLs trusted users.

High. All users are likely down.

  1. SQL Server is set to Windows mode Authentication Mode instead of SQL Server Authentication and Windows Authentication Mode (also called Mixed Mode). In Windows Authentication Mode, only Windows logins are allowed.
  2. Alternately, SQL could be in Mixed Mode but the cyrious user not exist
  3. Alternately, SQL could be in Mixed Mode but the cyrious user does not have permissions to connect to the StoreData database.
  1. Set SQL Server to SQL Server and Windows Authentication Mode (Mixed Mode)
    • Open SQL and connect to the Cyrious instance or instance which houses the Control StoreData
    • Right-click on the SQL Server instance name then go to Properties
    • Select the Security option on the left hand side
    • In the section labeled Server Authentication chose the “SQL Server and Windows Authentication mode”
  2. Add the cyrious user if it does not exist
    • ??
  3. If you still get the error message, Delete the cyrious user from the database and SQL management setup and recreate both.
    • ??
You could leave a comment if you were logged in.