SSIS service - log on as ?

Last Post 22 Nov 2011 05:02 AM by rm. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dstoltz
New Member
New Member

--
21 Nov 2011 06:19 AM
I've been migrating my DTS packages to SSIS on a SQL 2008R2 box.

I'm not sure why, but the SSIS service stopped working - it would not allow me to start it. Would error out and say:

Error 1053: The service did not respond to the start or control request in a timely fashion"


I read some articles on this, and the fix for me was to simply change the way the service starts from starting as "NETWORKSERVICE" to "local system account" - the service starts fine now...

Does anyone see any problems with starting the service like this? What is the default for starting the SSIS service?

Thanks!
rm
New Member
New Member

--
21 Nov 2011 11:09 AM
It runs under networkservice without issue on our servers, you may double check user rights of it on the machine.
dstoltz
New Member
New Member

--
22 Nov 2011 03:57 AM
If I switch it back to NETWORK SERVICES and try to start the service, it fails and the application log shows:
Microsoft SSIS Service failed to start.
Error: Configuration system failed to initialize

Not sure how any rights of that account would have changed - this seems to have started after last weeks Windows Updates but I can't be sure...

How do I ensure the NETWORK SERVICES account has the appropriate rights?
rm
New Member
New Member

--
22 Nov 2011 05:02 AM
It has following default user rights on our servers:

adjust memory quotas for a process
bypass traverse checking
create global objects
generate security audits
impersonate a client after authentication
replace a process level token


Acceptable Use Policy
---