February 13, 2014 at 10:50 am
We have set up service accounts for applications but some time developers log in to servers using thses service accounts. I want to prevent this by saving all the service accounts for that specific server in a table and then create a job that will notify if somebody tries to login to the server using those service accounts. This job will also capture the hostname(machine name) from where the login attempt was made.
February 13, 2014 at 11:01 am
You can do that via a logon trigger at the server level.
Here is an article on that
http://jasonbrimhall.info/2010/04/06/ip-and-default-trace-t-sql-tuesday-005/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply