SQL Databases Linked to applications
A couple of relatively straight forward ways may be to create a logon trigger (it also talks about event notifications in that article), writing the login events to some audit table, or periodically query the sys.dm_exec_sessions DMV say in a SQL Server Agent job and record the information from that.