Top menu

‘Login failed for user ‘user_name’ error when testing connection to SQL Server

DESCRIPTION

The connection test fails returning the ‘Login failed for user use_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.

COMMENTS

The error indicates that an incorrect user name (login), or password, or both have been specified for SQL Authentication selected in DeviceLock Enterprise Server options. Please note, that SQL accounts differ from regular Windows ones, which makes it impossible to use the latter in the ‘Login name’ parameter when SQL Authentication is selected. To manage SQL accounts, use SQL Server management consoles (e.g., Microsoft SQL Server Management Studio).  

RECOMMENDATIONS

Make sure that specified SQL account credentials are correct and do belong to an existing SQL account.