locked
Access denied when connecting Integration Services service` RRS feed

  • Question

  • Hi ya, I'm using my own Windows user. Such user belong to Admin group. What's more, my Integration Services is started using this same user.

    What's happening here? 

    Any advice or help would be very appreciated,

    Version:

    Microsoft SQL Server Management Studio 11.0.3153.0

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to xxxxxx

    Connecting to the Integration Services service on the computer "xxxxx" failed with the following error: "Acceso denegado."

    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.


    For help, click: http://go.microsoft.com/fwlink/?LinkId=220763

    ------------------------------

    Connecting to the Integration Services service on the computer "xxxxx" failed with the following error: "Acceso denegado."

    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.


    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Enric

    Sunday, March 15, 2015 4:53 PM

Answers

  • Close your SQL Server Management Studio (SSMS).

    Open SSMS by right clicking Run as Administrator and then try to login to Integration Services.

    If it doesn't work then double check if your account has admin rights on installed SQL Server.


    Cheers,
    Vaibhav Chaudhari

    • Marked as answer by Enric Vives Sunday, March 15, 2015 5:24 PM
    Sunday, March 15, 2015 5:17 PM

All replies

  • Close your SQL Server Management Studio (SSMS).

    Open SSMS by right clicking Run as Administrator and then try to login to Integration Services.

    If it doesn't work then double check if your account has admin rights on installed SQL Server.


    Cheers,
    Vaibhav Chaudhari

    • Marked as answer by Enric Vives Sunday, March 15, 2015 5:24 PM
    Sunday, March 15, 2015 5:17 PM
  • cheers, right on the target, thanks for that
    Sunday, March 15, 2015 5:23 PM