"DeviceLock Enterprise Server cannot access SQL Server. Do you want to change connection parameters?" error message when connecting to DeviceLock Enterprise Server via DeviceLock Management Console
DESCRIPTIONWhen trying to connect to DeviceLock Enterprise Server a message "DeviceLock Enterprise Server cannot access SQL Server. Do you want to change connection parameters?" appears. When configuring the parameters, after pressing "Test connection" button, "[Microsoft][ODBC SQL Server Driver]An attempt to allocate memory failed.", "[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed" errors come up.
COMMENTSThis problem belongs to SQL Server and is likely to be caused by a low memory condition.
RECOMMENDATIONS1. Make sure you have plenty of physical memory on SQL Server machine (check its virtual memory settings as well);
2. Make sure that SQL Server Agent service is not running under LocalSystem account. If you have this serviceáárunning under some domain account, reassign it;
3. The following Microsoft article recommends to call SQLGetDiagRec with a HandleType of SQL_HANDLE_DBC and a Handle ofááConnectionHandle to get more information about the error: