Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Logs Expand / Collapse
Author
Message
Posted Wednesday, January 22, 2014 2:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:28 AM
Points: 54, Visits: 1,294
SQL Server Logs is filled with one specific failed login. I disabled the account, but the failed login still writes to the Logs. How can I prevent this? I don't want to disabled the failed logins feature on the server properties. Thank you.
Post #1533834
Posted Wednesday, January 22, 2014 3:34 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
You need to prevent it from repeatedly trying to connect to SQL. this could even be a hacking attempt. The login failure message should give an ip address for the client, start there, talk to your sysadmins and\or security people

---------------------------------------------------------------------

Post #1533872
Posted Wednesday, January 22, 2014 3:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:28 AM
Points: 54, Visits: 1,294
Thanks, George. I will talk to our system admin. but at the same time, since all the failed logins are recorded in the Error Logs, which makes it grows fast. Is there a way to prevent writing the specific failed logins to the Logs?
Post #1533877
Posted Wednesday, January 22, 2014 5:05 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
other than the obvious you understandably don't want to use, I don't know of a way. There may be a trace flag to change this behaviour.

---------------------------------------------------------------------

Post #1533884
Posted Thursday, January 23, 2014 2:50 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 40,210, Visits: 36,619
You can prevent all failed logins from writing to the log, but not one specifically


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1533952
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse