Post reply

Without enable login auditing may I know who has stopped the sql server agent service?

  • September 22, 2011 at 1:29 am

    #257655

    Without enable login auditing may I know who has stopped the sql server agent service?

    Thanks

  • September 22, 2011 at 5:56 am

    #1385072

    I'm afraid you can't.

    I checked the event viewer and sqlagent.out, but there's no user info there.

    -- Gianluca Sartori

  • September 22, 2011 at 6:00 am

    #1385075

    I am not getting your reply, are u in my favor?

    Thanks

  • September 22, 2011 at 6:05 am

    #1385080

    forsqlserver (9/22/2011)

    I am not getting your reply, are u in my favor?

    I'm sorry, I see that my reply is confusing.

    I wanted to say that I have tried stopping/starting the SQLAgent on my laptop and I could not find the user info nor in the Windows Event Viewer, nor in the sqlagent.out file. I wouldn't know where else to check, so I guess there's no way to know who stopped it.

    -- Gianluca Sartori

  • September 22, 2011 at 8:33 am

    #1385201

    I think you should be able to find it under System category in Event Viewer. You are probably looking at Application tab/category. So if you select system, you should see an entry with Service Control Manager under Source. This should generally show who stopped the services. However, when I restarted SQL Agent from SSMS, it showed user name as system.

    If Sql agent has been restarted from the services console, it should put the name of the user if I am not wrong.

Viewing 5 posts - 1 through 4 (of 4 total)

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