Monday, March 12, 2012

Repeated Login failed for user SA in Event Log.

At regular intervals there are failed login message for User SA, User User,
User Root in the event log. This seems to have started after Security Patche
s
were applied.
How do I stop these failed logins occuring?
Thanks
--
John Franks MIScT, MIAP, MCSA, MCSE, MCDBACheck the Enterprise manager settings for configuration of SQL Agent.
Try changing SQL Agent to use Windows Authentication instead of Standard
Security.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks Kevin, we are already using Window authentication, any other
suggestions '
"Kevin McDonnell [MSFT]" wrote:

> Check the Enterprise manager settings for configuration of SQL Agent.
> Try changing SQL Agent to use Windows Authentication instead of Standard
> Security.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Otherwise, you could use SQL Profiler to capture failed login events to try
to find out what application is causing them, or run a network trace .
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment