‘Login failed for user 'computer_name$'’ error when testing connection to SQL Server
DESCRIPTIONThe connection test fails returning the ‘Login failed for user 'computer_name$’ error when testing connection to SQL Server by pressing ‘Test connection button’ either during the installation of DeviceLock Enterprise Server, or in DeviceLock Management Console -> DeviceLock Enterprise Server options.
COMMENTSThe error indicates that Windows Authentication has been selected in DeviceLock Enterprise Server options, but the user account used to run the DeviceLock Enterprise Server’s service (specified in the ‘Log on as’ parameter) cannot get access to the computer where SQL Server is running. It may happen when the DeviceLock Enterprise Server service starts either under the SYSTEM user or on behalf of a user that does not have local administrative privileges on the remote SQL Server computer.
RECOMMENDATIONS1. Use SQL Server authentication to connect to SQL Server under privileged user;
2. Specify a user account (in the ‘Log on as’ parameter) that does have local administrative privileges on the remote SQL Server computer.