By default SQL Server logs only failed login in ErrorLog and this only with user name without further details.
You have to change the logging mode, see
Or you have to implement an own logging.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How to get last user login details connected the database in SQL server
By default SQL Server logs only failed login in ErrorLog and this only with user name without further details.
You have to change the logging mode, see
Or you have to implement an own logging.
This query gives you the login times for the users currently logged in:
SELECT login_time, login_name FROM sys.dm_exec_sessions WHERE is_user_process = 1