Connection manager not properly installed
New: 17 July 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399 |
Event ID |
Not applicable |
Event Source |
Not applicable |
Component |
Integration Services |
Symbolic Name |
Not applicable |
Message Text |
The connection manager '%1' is not properly installed on this computer. |
Explanation
This message indicates that SSIS Designer has encountered an error involving Registry permissions while enumerating the connection managers installed on the computer.
Possible Causes
This message might appear because of one of the following problems:
- There is at least one Registry key in the HKEY_CLASSES_ROOT\CLSID section of the Registry for which the current account does not have Read permissions.
User Action
Do not reinstall SQL Server or other components
This error is not related to the installation of SQL Server or its components and cannot be resolved by uninstalling or reinstalling them. You must fix the root cause as described in the following section.
Fix the problem with permissions in the Registry
Integration Services relies on the COM API function EnumClassesOfCategories to enumerate connection managers that are installed on the computer. This function fails with an error if it encounters a class in the Registry whose keys the current account does not have permission to read. The solution is to locate the keys that are causing the problem and to grant at least Read permissions to the Users group on those keys. Microsoft Knowledge Base article 913817 provides C# code that you can compile and run to locate the keys that are causing the problem, and explains the steps that you can follow to fix the keys.
See Also
Other Resources
Microsoft Knowledge Base article 913817