So I've noticed thousands of
login failed for user S.A. after I've changed sa password. We all agreed with this, its a test environment and nobody was using SA and since i'm new here I would like to have all SA password. Nobody noticed any problem, but I can see this strange behavior running a trace on the server:
I've never seen such thing. hostname and appname is just random characters. Has anyone seen this before?
The login is failing so this query above has no use:
SELECT s.session_id, s.login_name, DB_NAME(s.database_id) as database_name, s.host_name, s.program_name, c.client_net_address, client_tcp_port, c.net_transport, c.auth_scheme, s.login_time FROM sys.dm_exec_sessions s INNER JOIN sys.dm_exec_connections c ON s.session_id = c.session_id ORDER BY s.session_id