Jump to content


  • 0
Elemanzer

Unauthorized Login for servers... would like a SQL one

Question

I made a monitor that send an email to me if someone other than me logs into a server.

 

Security logs

Event ID 4624

parameter 9 equals 10

parameter 6 not equal "my username"

 

For the alerting I used

$Data/Context/Params/Param[6]$ logged into
$Data/Context/Params/Param[12]$ from
$Data/Context/Params/Param[19]$

 

So it'll tell me who and when they logged into the server.

 

I can even kill term services with running a cmd line net stop termservice /y

 

What i would like is one that shows when someone logs into SQL with a service account.

Any suggestions?

 

 

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Elemanzer, are you trying to monitor when an actual users logs into a SQL server (i.e. the actual Windows server) using a Service Account, or when a Service Account connects with/to a SQL Server instance?

 

Also, why did you create a custom monitor to monitor when someone other than you logs into a server, instead of implementing ACS which is much more robust in its data collection/reporting?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.