Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mnash2014
Starting Member
1 Post |
 Posted - 2014-10-17 : 06:21:30
|
| Thanks in advance for any help.We have a particular database sat on SQL Server 2012 box along with about 20 other databases.What I require is a method/Script/Audit (Open minded about the solution) that will simply track anyone who logs (successfully / unsuccessful) into this one particular database on the server (The single database is the key as the end user does not want information on any of the other databases that sit on the server), it also has to log time the attempt was made and it must track the logins via SQL Server or the application itself that is attached to the database. Once we have this information we need to simply store that somehow. I say somehow as the storing part depends on the solutions recommended to me, so I’m open minded about this too.Any help would be great as I’m scratching my head on this one. |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-10-17 : 09:25:49
|
| I guess easy option would be to create Logon trigger. Please see MSDN documentation . http://msdn.microsoft.com/en-us/library/bb326598%28v=sql.110%29.aspxIts also worth reading Logon trigger execution guidelines http://technet.microsoft.com/en-us/library/bb153915%28v=sql.105%29.aspxHope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
|
|
|
Track all logins on to a single SQL database