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