Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMS 2008 R2 There are not enough resources to complete the operation. Expand / Collapse
Author
Message
Posted Friday, January 6, 2012 8:48 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
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
Post #1231528
Posted Friday, January 13, 2012 3:49 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:29 PM
Points: 2,007, Visits: 6,077
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
Post #1236024
Posted Saturday, January 14, 2012 1:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:56 AM
Points: 2,013, Visits: 1,584
• 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


Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T) | Open Network for Data Professionals...
LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1236109
Posted Thursday, April 19, 2012 3:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 9, 2013 1:41 AM
Points: 2, Visits: 11
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
Post #1286292
Posted Thursday, April 19, 2012 4:51 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
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
Post #1286316
Posted Thursday, April 19, 2012 5:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 9, 2013 1:41 AM
Points: 2, Visits: 11
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
Post #1286338
Posted Thursday, April 19, 2012 5:49 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
yes, I replaced myname w/ my account..

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


BT
Post #1286345
Posted Wednesday, October 30, 2013 9:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:49 AM
Points: 1, Visits: 25
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.
Post #1509844
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse