March 31, 2010 at 10:43 am
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
March 31, 2010 at 11:05 am
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:
March 31, 2010 at 5:39 pm
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
March 31, 2010 at 8:45 pm
No.
March 31, 2010 at 9:54 pm
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.
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
April 5, 2010 at 5:43 pm
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
March 27, 2014 at 10:19 am
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