Symptoms
When synchronizing a data source in the Jet Data Manager, an error about creating enhancements appears and indicates "Access is denied" when connecting to Integration Services.
"Error creating enhancements!
Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied."
By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrator privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service."
Resolution
When using SQL Server 2012 or later it may be necessary to change the DCOM permissions for SSIS so users are not required to run the Jet Data Manager as an Administrator.
-
While logged in with Administrator permissions, navigate to Control Panel → Administrative Tools → Component Services.
-
Expand Component Services → Computers → My Computer → DCOM Config.
Find the component object entitled Microsoft SQL Service Integration Services x.x (x.x being the version installed on the machine).
-
Right click on the Microsoft SQL Service Integration Services object and select Properties.
-
In the window, select the Security Tab.
Under Launch and Activate Permissions click Edit...
Add the appropriate user(s) or group(s). Grant permissions for Local Launch and Local Activation.
Click OK and click Apply to commit the changes.
-
Under Access Permissions click Edit...
Add the appropriate user(s) or group(s). Grant permissions for Local Access.
Click OK and click Apply to commit the changes.
"Launch rights" grant or deny permission to start and stop the service; "Activation rights" grant or deny permission to connect to the service. -
Once you have completed, you will be required to restart the SSIS service.
From the start menu navigate to the SQL Servers Configuration Manager, right click SQL Server Integration Services, and Restart.
Comments