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.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Track all logins on to a single SQL database

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.aspx
Its also worth reading Logon trigger execution guidelines http://technet.microsoft.com/en-us/library/bb153915%28v=sql.105%29.aspx

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -