Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to filter event log to show SQL logon that was initiated from other machines, I have thousands of logins from local machine and few ones from other machines. I want to monitor that connections from other machines. Only difference in that two events is in text.

Local connection :

Login succeeded for user 'tel_writer'. 
Connection made using SQL Server authentication. 
[CLIENT: <local machine>]

Other machine connection:

Login succeeded for user 'sa'. 
Connection made using SQL Server authentication. 
[CLIENT: 242.xxx.xxx.xxx]

Is there a any way to filer out this local machine connections ?

share|improve this question
    
This is similar to an question i had, regarding logins to the computer itself (serverfault.com/questions/157187/…) –  Ian Boyd Dec 3 '10 at 23:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.