‘Login failed for user ‘user_name’. The user is not associated with a trusted SQL Server connection’ error when testing connection to SQL Server
DESCRIPTIONWhen configuring DeviceLock Enterprise Server options (during or after the installation of the server), the connection test (performed by pressing the Test connection button) fails returning the Login failed for user ‘user_name’. The user is not associated with a trusted SQL Server connection error.
COMMENTSThe error indicates that Windows authentication has been selected in DeviceLock Enterprise Server options while the account specified in Startup account of DeviceLock Server Options (e.g., SYSTEM) does not have enough privileges on your SQL Server, or your SQL Server has not been configured to work in mixed (SQL Server and Windows authentication) mode.
SQL accounts differ from regular Windows ones, which means that the account used for running DeviceLock Enterprise Server's service might not be existing on SQL Server, making it impossible to use Windows Authentication.
RECOMMENDATIONS1. Use SQL Server authentication to specify SQL Server administrator account;
2. Use Windows authentication and allow SQL Server to work in mixed (SQL Server and Windows authentication) mode to be able to login with account specified in 'Startup account'*. You can configure this in your SQL Server properties -> Security -> Server Authentication;
This account must on exist on SQL Server with administrator privileges.