[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQLSERVERAGENT error in event log

Posted on 2008-11-13
14
Medium Priority
?
487 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:derekjr
  • 7
  • 6
13 Comments
 

Author Comment

by:derekjr
ID: 22949359
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
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 22957537
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
 

Author Comment

by:derekjr
ID: 22959569
i looked in server mangement studo under the  dql server agent and jobs. it listed the same error as in the event log.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 22973176
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
 

Author Comment

by:derekjr
ID: 22977700
From the sql server
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 22982970
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
 

Author Comment

by:derekjr
ID: 22996646
oh sorry. i thought i posted the screen shot
0
 

Author Comment

by:derekjr
ID: 22996653
when i go to attach the file. nothing shows up in the box
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 23009018
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
 

Author Comment

by:derekjr
ID: 23034946
Here is the screen shot.
ScreenHunter-03-Nov.-25-09.51.jpg
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 2000 total points
ID: 23039583
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
 

Author Comment

by:derekjr
ID: 23429727
Can i just upgrade to SP3. should i be aware of prereqs before i do this? We have server 2003 SP1.
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 23436107
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question