September 5, 2012 at 7:16 am
Hello
I gave a vendor a login to setup a database - the password of the account has expired and my log is filled with the message "Login failed for user 'McAfee_Install'. Reason: The password of the account has expired - disabling the account changed the message to "Could not find a login matching the name provided.
I ran sp_who2 on the db created (ePO4_EDINBURG1) and see 3 SPIDS > 50 awaiting command for the SQL Server Agent login.
I looked through all of the jobs under SQL Server Agent and have no jobs listed with the ePO4_EDINBURG1 db created by the vendor - I checked under local services and I can see McAfee Framework Services, McAfee McShield, McAfee Task Manager, McAfee Validation Trust Protection Service - I'm unable to stop these processes or verify they are trying to connect to the ePO4_EDINBURG1 db
I am running SQL Server 2008 Standard
Is there a way to tell what process is trying to connect to the database and stop it?
Thanks in advance for any help
Dave
September 5, 2012 at 8:05 am
If the server is configured to log failed logins in the error log, you can get the IP of the machine that has the application that tries to connect. You can also get it with profiler or server side trace that is configured to use the event failed login.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply