venkataramanaiahsr
asked on
Missing "Foreach File Enumerator and Foreach Item Enumerator
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.
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There seems to be some Registry issues. i installed SQL 2008R2 on fresh os installation and the problem is solved
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
HKEY_LOCAL_MACHINE\Softwar
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.