Error: Error creating enhancements! Connecting to the Integration Services service on the computer " " failed
Symptom
When attempting to execute a project, the following error message is displayed.
" Error creating enhancements! Connecting to the Integration Services service on the computer "{server name}" failed with the following error message: "Access is denied.""
Cause
This error is caused when SQL Server Integration Services (SSIS) has not been installed on the server, or if the service is stopped.
Resolution
-
Verify if Integration Services is installed.
Navigate to services from the start menu, and look for SQL Server Integration Services.
-
If the service is stopped, right click the service and click Properties.
Ensure the Startup type is set to Automatic and the service is Started.
-
If the service is not installed. you will need to install Integration Services on the server.
This can be accomplished by running the installation disk/media that was used during the initial installation.