Try on code similar like this
CREATE TABLE #errors
(errorlog varchar(255), continuationrow int)
INSERT #errors
(errorlog, continuationrow)
EXEC xp_readerrorlog
SELECT errorlog
FROM #errors WHERE errorlog LIKE '%Login failed%'
DROP TABLE #errors