SQLSERVERAGENT error in event log

Event Type:      Error
Event Source:      SQLSERVERAGENT
Event Category:      Alert Engine
Event ID:      318
Date:            11/13/2008
Time:            3:51:17 AM
User:            N/A
Computer:      NT17
Description:
Unable to read local eventlog (reason: The parameter is incorrect).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


 Can someone please tell me what this is? I keep getting in in my event log on my server 2003 box running sql server 2005.
derekjrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

derekjrAuthor Commented:
in doing some reading on this. it refers to another application on the  server having issues.  i found this on the same server in the event log

Event Type:      Warning
Event Source:      W3SVC
Event Category:      None
Event ID:      1013
Date:            11/13/2008
Time:            1:52:45 AM
User:            N/A
Computer:      NT17
Description:
A process serving application pool 'MSSharePointPortalAppPool' exceeded time limits during shut down. The process id was '7300'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
nmcdermaidCommented:
Does the event date and time correlate with any jobs set up in SQL Server Agent? Maybe there is a dodgy job that is failing.
0
derekjrAuthor Commented:
i looked in server mangement studo under the  dql server agent and jobs. it listed the same error as in the event log.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

nmcdermaidCommented:
Can you screenshot and post the error you're seeing? Is it a particular job or is it when you just click on SQL Server agent?
0
derekjrAuthor Commented:
From the sql server
0
nmcdermaidCommented:
I'm going to need more info than that. Thats why I need you to screenshot the screen you're seeing that is showing the error.
 
0
derekjrAuthor Commented:
oh sorry. i thought i posted the screen shot
0
derekjrAuthor Commented:
when i go to attach the file. nothing shows up in the box
0
nmcdermaidCommented:
1. Tick 'attach file'
2.. Press Add File
3. Browse to your file, press OK and wait
4. add a description
5. Press Submit.
Or you can explain to me in words exactly whatyou opened, where you navigated to, what you pressed, and exactly what message you see.
0
derekjrAuthor Commented:
Here is the screen shot.
ScreenHunter-03-Nov.-25-09.51.jpg
0
nmcdermaidCommented:
Apparently its a known bug:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124086&SiteID=1
So trying applying all the latest service packs.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
derekjrAuthor Commented:
Can i just upgrade to SP3. should i be aware of prereqs before i do this? We have server 2003 SP1.
0
nmcdermaidCommented:
I beleive SP's are cumulative so that should be fine. I guess all the prereqs would be in the readme for the SP. Sorry I do more development than admin.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.