Export (0) Print
Expand All

Connection manager not properly installed

SQL Server 2005

New: 17 July 2006

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.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft