up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

1 Answer

up vote 1 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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