Connecting to the Integration Services service on the computer "local host" failed with the following error: "Access is denied.
Introduction
Connecting to the Integration Services service on the computer "local host" failed with the following error: "Access is denied.
Issue
Once we installed the Integration services feature on the SQL server 2012,when we try to open the Integration services, it welcomes with the error” Connecting to the Integration Services service on the computer "local host" failed with the following error: "Access is denied”.
Even though, The account that we are using is Local administrator of server and have SYSAdmin privileges in the SQL.
Cause
User Access Control, can basically intercept requests for your group membership so in this case, it appears it was preventing your membership getting passed to SQL Server.
Solution
Follow the below steps to resolve the issue.
Right Click on the SQL Server Management Studio and select Run as Administrator and try to connect if it is installed on the local instance.
Note: I resolved the issue by above Method. If you find a different solution, please report it as a comment to this post. This will be useful to SharePoint Community. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.