May 19, 2015 at 12:31 pm
I have inherited a SQL Cluster with 150+ databases. Is there an easy... painless way to monitor which accounts are actually needed?
Thanks!
Charlie
May 19, 2015 at 12:43 pm
You can enable a server side trigger that logs every login.
You can log both successful and unsuccessful login attempts (security tab of server properties)
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
May 21, 2015 at 11:30 am
Like Jason said, a login trigger can be implemented to track login events to a log table. You can also use event notifications to do something similar, if you don't like the idea of a trigger. A server-side trace can be used, too. All three of those options are available in Standard and Enterprise edition. Depending on what version/edition you're on, you can also use SQL Audit to audit login events.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply