Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In one of our servers, SQL Server service though set to manual and its dependant services are stopped, still it starts automatically if we stop the SQL Server service.

Is there a utility or way to find out who or which service is starting SQL Server Service?

share|improve this question

1 Answer 1

Look in the System event log for Event ID 7035 from source Service Control Manager. This should tell you when the service was started and by whom.

share|improve this answer
    
Thanks for this tip. I see that in event ID 7035, source is always "Service Control Manager" but we don't have any of the dependant service running still SQL Server starts automatically. Any other tip? –  Sakthivel Chidambaram Mar 12 '10 at 13:54
    
The event log source is always Service Control Manager. You need to look in the text of the log entry to see what security principal issued the start command. –  joeqwerty Mar 12 '10 at 15:07
    
Thanks Joe. I will explore it further. –  Sakthivel Chidambaram Mar 12 '10 at 16:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.