We help IT Professionals succeed at work.

How to ignore or filter out certain SQL Server error log messages?

SEHC
SEHC asked
on
1,169 Views
Last Modified: 2012-06-27
Hi,

Is it possibly to ignore certain SQL Server 2000 errorlog messages?
We are getting Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. which we need to ignore or filter out.

Thanks.

 
Comment
Watch Question

Commented:
SEHC,

Let me know if the following might work, or be helpful in any way... of course, you could encapsulate the code into a store procedure, and pass parameters so that you could include or exclude any number of types of log entries.

Thanks!
David.
CREATE TABLE	#TempLog
			(LogDate DATETIME, ProcessInfo VARCHAR(50),
			 [Text] VARCHAR(2000))
 
INSERT INTO	#TempLog
EXEC		sp_readerrorlog
 
SELECT		*
FROM		#TempLog
WHERE		[Text] NOT LIKE
		'%Login failed for user ''(null)''.%'
 
DROP TABLE	#TempLog

Open in new window

SEHCAdmin

Author

Commented:
Hi DBoyes,

Thanks for your quick response.
What I'm looking for is to find a way to avoid recording "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." message in the actual "SQL Server errorlog", so even running the system stored procedure "sp_readerrorlog" will not contain this message.
Thanks.

Commented:
SEHC - I'm not sure that is possible, but I'll take a poke around during the course of today to make sure - bear with me, as I have a few other things going on today - I'll try to leave another reply before the end of the day.

Thx!

Commented:
SEHC - I was not able to find much more information.

I did find out that an SQL Agent Log can be tailored to include/Exclude Informational and/or Warning messages, but all I have to hand right now is a local copy of SQL Server 2005 Express, and the option does not appear to be available (Right-click and configure on "Management/SQL Server Logs".

I've put some feelers out to other colleagues, but it might take them a while to get back to me. Watch this space, but don't hold your breath!
SEHCAdmin

Author

Commented:
Thanks for the update DBoyes.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
SEHCAdmin

Author

Commented:
Hi David/DBoyes,

Thanks for your suggestions and the time spent, much appreciated.
The information your provided is indeed very useful .
Let me dig more into this, and I'll sure keep you updated here.

Regards,
Fazal
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.