Post reply

SSMS 2008 R2 There are not enough resources to complete the operation.

  • January 6, 2012 at 8:48 am

    #262575

    Every time I click open file from SSMS 2008 R2, I receive error msg:

    " Microsoft Office There are not enough resources to complete the operation. Save your work, close the programs, and then try again"

    I rebooted my machine multiple times. No luck. I am running Windows 7 Prof and SQL Server 2008 R2 Developer Edition.

    Thoughts??

    BT

  • January 13, 2012 at 3:49 pm

    #1433583

    How much memory are you running on your system? What other programs do you have open?

    Could just be as simple as not enough resources.


    Shamless self promotion - read my blog http://sirsql.net

  • January 14, 2012 at 1:52 am

    #1433662

    •Stop / disable the services in SQL Server (& others) that you are not currently using. It will minimize the memory utilization.

    •Also, provide min & max memory setting in SQL Server configuration.

    •Don’t use multiple programs (applications) at once.

    •Add more memory, if possible.

    For More:

    http://technet.microsoft.com/en-us/library/cc917563.aspx

    http://msdn.microsoft.com/en-us/library/ms178067.aspx

  • April 19, 2012 at 3:59 am

    #1475913

    Hi,

    I could resolve this issue on my machine (Windows7 plus MSSQL 2008 R2) by deleting

    C:\Users\myname\AppData\Local\Microsoft\Microsoft SQL Server\100\Tools\Shell

    and

    C:\Users\myname\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

    Good Luck,

    Juergen

  • April 19, 2012 at 4:51 am

    #1475933

    thanks for this feedback. Unfortunately, I do not see this path on my laptop:

    C:\Users\myname\AppData\Local\Microsoft\Microsoft SQL Server\100\Tools\Shell

    I have SQL Server 2008 R2 Developer Edition installed:

    -- Management Studio version 10.50.2425.0

    -- MDAC version 6.1.7601.17514

    -- MSXML versionn 3.0 5.0 6.0

    -- IE version 9.0.8112.16421

    -- .Net Framework version 2.0.50727.5448

    -- OS is Windows 7 Professional (w/ sp1) version 6.1.7601

    any idea where the "\Tools\Shell" directory resides in this config? a Search on SHELL rendered no results.

    (fyi, when I do get the error, "There are not enough resources to complete the operation...." I simply click IGNORE and it passes thru to my Windows Explorer to present my Directories/Files.. just an annoying error msg)

    BT

  • April 19, 2012 at 5:43 am

    #1475952

    Any button worked for me to continue, but the message box is just too annoying.

    In other forums (with other versions of SQL Server) people reported that this issue can get worse ...

    I have got exactly the same components and versions as yours.

    Please excuse my silly question:

    Did you replace the myname string in the path with your windows logon name?

    Are you using a domain account? with roaming enabled?

    We use domain accounts, but not roaming profiles.

    I noticed that when I deleted both folders, after restarting SSMS the Shell folder in the Roaming tree got recreated immediately.

    The corresponding folder in the Local tree got recreated only after some time - with the file CmdUI.PRF in it - Windows 7 recognises it as an Outlook preferences file (I suppose that is where "Office" in the caption of the error dialog comes from ...)

    I hope my thoughts are helpful.

    J

  • April 19, 2012 at 5:49 am

    #1475958

    yes, I replaced myname w/ my account..

    Not sure about the Roaming attribute.. need to check that

    BT

  • October 30, 2013 at 9:34 am

    #1662769

    I had the same issue. When the Open File window opened and the error message appeared, I noticed that the Open File window was full window sized instead of the normal smaller window size. I right clicked on the top bar of the open file window and clicked "Restore" which re-set it to a smaller window. That cured the issue with SSMS.

  • October 12, 2015 at 6:52 pm

    #1832899

    Thanks Forum Newbie. This was driving me crazy. By changing the restore to the smaller window worked.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply