Differences

This shows you the differences between two versions of the page.

Link to this comparison view

control_error_-_login_failed_for_user_cyrious [2019/01/27 11:28] (current)
Line 1: Line 1:
 +====== ​ ======
 +
 +
 +
 +===== Error Message =====
 +
 +
 +
 +Database connection failed: Login failed for user '​cyrious'​. The user is not associated with a trusted SQL Server connection.
 +
 +
 +
 +===== Explanation of Error =====
 +
 +
 +
 +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.
 +
 +
 +
 +===== Severity =====
 +
 +**High**. All users are likely down.
 +
 +
 +
 +===== Possible Root Cause(s) =====
 +  - 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.
 +  - Alternately,​ SQL could be in Mixed Mode but the cyrious user not exist
 +  - Alternately,​ SQL could be in Mixed Mode but the cyrious user does not have permissions to connect to the StoreData database.
 +
 +
 +
 +===== Resolution =====
 +  - 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"
 +  - Add the cyrious user if it does not exist
 +    *  ??
 +  - If you still get the error message, Delete the cyrious user from the database **and** SQL management setup and recreate both.
 +    *  ??
 +
 +
 +