Missing "Foreach File Enumerator and Foreach Item Enumerator

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
I did a fresh Sql2008R2 installation in winxp with sp3 (evaluation). The installation went thro smoothly without any erros. But when i go to For each loop container , the above said enumarators are missing. When i install the same edition in win2003 member server , i am getting the said enumarators. I even installed sql2008R2 sp1 on winxp. Still  the said enumarator is missing.  I googled a lot and did few things like installing sql server under local user account with admin privilages , going to the register and setting permissions for clsid. Nothing seems to be working.  Can somebody solve this problem.

Question by:venkataramanaiahsr
  • 3

Expert Comment

ID: 36968671
Just a shot in the dark here, but I dug this up:

This behavior occurs because the installation of a third-party application or of a third-party driver may incorrectly set up the permissions of the registry subkeys under the
subtree. If the Component Category Manager encounters a registry key for which it does not have read permissions, it reports an access error and stops enumerating components. Therefore, the Component Category Manager cannot enumerate the SSIS components that have a CLSID that has incorrect permissions in the subtree.

Applications that are known to possibly cause this behavior are Lexmark printer drivers (Lexdrvx.dll) and Macromedia Flash. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
300491  (http://support.microsoft.com/kb/300491/ ) FIX: Applications that use Component Categories Manager with non-Administrator credentials fail on Application Center

Let us know if this helps.

Author Comment

ID: 36968907
I did give rights (Full control) clsid for both sqlservice user a/c ( local user ac) and the loggin in a/c ( domain a/c) . Both users have respecitve administrative privilages.  I donot have lexmark printer drivers installed on my machine. I did not get what application center has got to do with this. Can you pls elobarate on this?


Accepted Solution

venkataramanaiahsr earned 0 total points
ID: 37049757
There seems to be some Registry issues. i installed  SQL 2008R2 on fresh os installation and the problem is soloved

Author Closing Comment

ID: 37074929
There seems to be some Registry issues. i installed  SQL 2008R2 on fresh os installation and the problem is solved

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question