October 30, 2014 at 10:48 pm
Hi All,
Is it possible to find an application name on a particular time in the past through DMVs.
I came across the situation where login failed to access the db. It happened 10 days ago. They want to know through which application, it is connected.
Is it possible to find the application name?
October 31, 2014 at 1:24 pm
If the login failed, then there won't be a session for you to use the DMVs against. Typically you'd find that kind of information in: sys.dm_exec_sessions in the program_name column if they did actually make a connection.
The only information that gets captured for failed logins that I'm aware of is in the SQL Server Logs, the source IP address and the username. You can find those through SQL Server Management Studio in the Object Excplorer:
Management\SQL Server Logs\(separate files listed by most recent entry)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply