Skip to main content

Need Help Using Spok Knowledge?

Certain site features may not be supported by older versions of Internet Explorer.
Chrome, Edge, Firefox, or Safari will provide the most optimal experience.

SQL Insufficient Memory Error


Customers running SQL 2012 - SP1 may get insufficient memory errors.   

This is a known memory leak issue with Service Pack 1.   This will continue to occur unless the SQL service pack is updated - recommend Service Pack 3.

Temporary Resolution:  Restart server


To check the SQL Service Pack:

    Open SQL Server Management Studio
  Create a new query
        Query:    SELECT @@VERSION 

     Execute the Query

Note: you may need to restart the server to clear the memory error before you can log into SQL Server Management Studio to check the version.

Some symptoms may include:

         - Cannot access EADM, receive "No process is on the other end of the pipe" error. 

- Cannot log into SQL Server Management studio. 

- Cannot restart SQL Services

- Receiving "named pipe" error