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.
No comments:
Post a Comment
Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula