none
Access denied -SSIS REMOTE CONNECTION DOES NOT WORK

    Question

  • Hello All,

    We have server where we have SQL SERVER 2008 R2 STD installed. I am trying to connect SSIS on the local machine and it works fine but when I try to connect from an other server using SSMS I get the below error.

    The user I am trying to use is not an admin he has got all the access on MSDB DB.

    Tried all the options on DCOM config nothing helps...Any Idea's??

    Error Message from SSMS:

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

    Cannot connect to ******.

    ------------------------------
    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 "*****" 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 "****" 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.

    <input id="5582f54f-2ac2-4165-93e9-c8f0b778948a_attachments" type="hidden" />
    Friday, September 21, 2012 5:16 PM

Answers

All replies