SSIS will not start

  • I can't get SSIS server to start. Keep getting the error. "the request failed or the service did not start in a timely fashon." and this in the event log:

    Event Type:Error

    Event Source:DCOM

    Event Category:None

    Event ID:10005

    Date:3/31/2010

    Time:9:56:25 AM

    User:N/A

    Computer:DECSQLP01

    Description:

    DCOM got error "The service did not respond to the start or control request in a timely fashion. " attempting to start the service MsDtsServer with arguments "" in order to run the server:

    {ABF05265-635E-44B0-A28F-AEA45247ACA0}

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    So far I can't find what this issue is.

    Running Win server 2003

    SQL 2005 Ent SP3 w/cumm update 3

  • I swithed the service account to the domain account SQL runs under and now it started. Not sure why it won't start under the built in network service. We just built out 6 servers and all the others start and run under the built in network service.

    :crazy:

  • Are there any other error messages along with that message?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • No.

  • Though you have it resolved, here is a link with a reason as to why it may have happened. This doesn't explain why it only failed on the one server though. I think I would probably change all the servers to have the same account on the service and the same permissions for that account.

    http://blogs.msdn.com/bindeshv/archive/2008/03/06/ssis-service-fails-with-error-access-denied-at-startup.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • As an aside, the SSIS service is usually not required to execute SSIS packages: http://msdn.microsoft.com/en-us/library/ms140100.aspx

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • I had the same issue but with my analysis the NETWORK SERVICE needed the following:

    'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config' - Desired Access: Generic Read

    Granted READ access for NETWORK SERVICE to that file and SSIS service started fine.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply