65758: DeviceLock DLP: "[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

use Google Translate

Applies to: 

Last update: Tue, 2020-11-17 09:48

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.aspxhttp://msdn.micros...(VS.85).aspx