- Marek Vavrovic
Connecting to Integration Services Access is Denied in SQL Server
Connection to the Integration Services service on the computer " XXX " failed with the following error: "Access is denied"
By default only administrators have access to the Integration Services service. The process must be running with administrative privileges in order to connect to the Integration Services service.
For users who have worked with older versions of SQL Server, this can be surprising as connecting to SSIS with SSMS usually does not have problems. The reason for this is that in the older versions, all users of the "Users" group had access to SSIS by default. In the newer versions of SQL Server, however, access is secure by default and it must be granted to a specific user who needs to connect to that service.
Open a "Command prompt" and type Dcomcnfg.exe
This opens the "Component Services"
Find your version of "Microsoft SQL Server Integration Services" . Right-click on it and choose "Properties".
select "Security" tab
"Launch and Activation Permissions" and "Access Permissions" for our user.
Click "Edit" on "Launch and Activation Permissions".
Then click "Add" we find the user and grant the corresponding permissions.
Restart the Integration Services service
try to connect to Integration Services again