Top menu

"[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

DESCRIPTION

When 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.

COMMENTS

This problem belongs to SQL Server and is likely to be caused by a low memory condition.

RECOMMENDATIONS

1. 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:
http://msdn2.microsoft.com/en-us/library/ms711810.aspx
http://msdn.microsoft.com/en-us/library/ms711727(VS.85).aspx