none
Error when connecting to Integration Services from Management Studio

    Question

  • Hello,

    I am getting this error when I am connecting to Integration Services from SQL Server Management studio.

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

    Cannot connect to EECOLO2.

    ------------------------------
    ADDITIONAL INFORMATION:

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

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

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

    This error occurs when the computer has not been configured to allow remote connections through DCOM, or the user does not have permission to access the SQL Server Integration Services service through DCOM.


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

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

    This error occurs when the computer has not been configured to allow remote connections through DCOM, or the user does not have permission to access the SQL Server Integration Services service through DCOM.


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

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

    Please help me with this.

    Thanks

    Thursday, November 17, 2011 6:24 PM

Answers

  • Speak with whoever is the administrator to give you the access.
    Arthur My Blog
    • Proposed as answer by Tarakq Thursday, November 17, 2011 8:53 PM
    • Marked as answer by Eileen Zhao Thursday, November 24, 2011 8:33 AM
    Thursday, November 17, 2011 7:19 PM
    Moderator

All replies