Tuesday, May 6, 2014

Connecting to the Integration Services service on the computer "local host" failed with the following error: "Access is denied.

 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.
                                           

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

No comments:

Post a Comment

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X