Post reply

Error Log issue

  • January 11, 2015 at 11:54 pm

    #302373

    Hi All,

    I am getting error message in error log

    "Message

    [LOG] Unable to read local eventlog (reason: The parameter is incorrect)".

    I could not identify what is the problem. and that error is continuos coming every 30 minute interval.

    Please help me to resolve this issue.

    Thanks,

    Arooj

  • January 12, 2015 at 12:36 am

    #1769405

    This is generally an error found in the SQL Server Agent error log, not the error log for SQL Server (database engine). This has something to do with SQL Server Agent trying to read the local Windows Event log for alert purposes. This was a bug in SQL Server 2005 RTM I believe but was fixed in SP1. I am not aware of it being an issue in SQL Server 2008 (the forum you posted the question in).

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • January 12, 2015 at 12:45 am

    #1769407

    I apologize Shawn, You are correct , this error is coming SQL SERVER agent error log in Version 2005 SP2. By mistake I have posted this issue in this forum.

    Please find my SQL SERVER version:

    "Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ".

    And please give me some suggestion , what possible I can do to resolve this issue.

    Or should I post this issue in 2005 forum . Kindly advise.

    Thanks

  • January 12, 2015 at 12:49 am

    #1769409

    arooj300 (1/12/2015)

    I apologize Shawn, You are correct , this error is coming SQL SERVER agent error log in Version 2005 SP2. By mistake I have posted this issue in this forum.

    Please find my SQL SERVER version:

    "Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ".

    And please give me some suggestion , what possible I can do to resolve this issue.

    Or should I post this issue in 2005 forum . Kindly advise.

    Thanks

    Well right off, you are not running SQL Server 2005 SP2 if you build number is 9.00.1399, because that is RTM. So I would suggst patching your instance.

    However, also note that SQL Server 2005 is out of support and you should look at upgrading to SQL Server 2012/2014.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • January 12, 2015 at 1:27 am

    #1769419

    Thanks Shawn for you support 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply