"[Microsoft][ODBC SQL Server Driver]An attempt to allocate memory failed.", "[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed" errors when testing connection to SQL Server
DESCRIPTIONWhen installing DeviceLock Enterprise Server, or configuring its parameters, "[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 after pressing the 'Test connection' button.
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: