Differences
This shows you the differences between two versions of the page.
— |
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 ' | ||
+ | |||
+ | |||
+ | |||
+ | ===== Explanation of Error ===== | ||
+ | |||
+ | |||
+ | |||
+ | All connections from Cyrious Control and the SSLIP log into SQL using a SQL user called " | ||
+ | |||
+ | |||
+ | |||
+ | ===== 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). | ||
+ | - Alternately, | ||
+ | - Alternately, | ||
+ | |||
+ | |||
+ | |||
+ | ===== 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. | ||
+ | * ?? | ||
+ | |||
+ | |||
+ | |||