« How to redirect an HTTP connection to HTTPS for Outlook Web Access clients and how to redirect the Default Web Site to point to the Exchange virtual directory
Speed Up Windows 7 Guide »

Logging thousands of errors, oerflib and sbsmonitoring

I’m receiving these two errors again and again:

 

Windows cannot load extensible counter DLL MSSQL$MSFW, the first DWORD in data section is the Windows error code.

 

Windows cannot load extensible counter DLL MSSQL$SBSMONITORING, the first DWORD in data section is the Windows error code.

 

What might be generating them and how can I cure it?

 

The system is SBS 2003 R2 Premium.

 

Thanks.

 

Answers

  • TrxAdmin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsThursday, May 10, 2007 1:57 PM

    Helpful Votes0 votesVote As Helpful

    Answer

    According to the KB article below, it is a permissions issue:

    “To resolve this problem, you must grant the Read & Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services.

    http://support.microsoft.com/kb/912399

     

All Replies

  • mrdennyMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsThursday, May 10, 2007 1:57 AM

    Helpful Votes0 votesVote As Helpful
    Where are you seeing these errors?
     
  • TrxAdmin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsThursday, May 10, 2007 1:46 PM

    Helpful Votes0 votesVote As Helpful
    I am also getting thousands of these errors in the application log of 3 SBS machines.

    They are all running SBS 2k3 sp1, at least 1 of them is R2 version of 2k3.

     
  • TrxAdmin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsThursday, May 10, 2007 1:57 PM

    Helpful Votes0 votesVote As Helpful

    Answer

    According to the KB article below, it is a permissions issue:

    “To resolve this problem, you must grant the Read & Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services.

    http://support.microsoft.com/kb/912399

     
  • Old Blind Dog Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsFriday, May 11, 2007 11:56 AM

    Helpful Votes0 votesVote As Helpful

    The 912399 article says:

    RESOLUTION

    To resolve this problem, you must grant the Read & Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services. The DLL is located in the following folder:

    C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Bin\Msmdctr90.dll

    Additionally, you must grant Read permissions to the Network Service account on the “bin” directory and the “bin\en” directory for SQL Server 2005 Analysis Services. For example:

    • C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin
    • C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin\en

     

    I didn’t have those specific directories, but I gave Network Service permissions for any similarly named directories and it fixed the problem. Thanks

    Any idea what created the problem to begin with?

     
  • Anonymousbhnmkjh Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers MedalsMonday, May 14, 2007 11:04 AM

    Helpful Votes0 votesVote As Helpful

    I have this problem for an earlier MSSQL server version which does not have the same structure.  does anyone know the method for this?

     

     

     
Need Help with Forums? (FAQ)

Statistics

  • Started: 5/4/2007
  • Last Reply: 5/11/2007
  • Helpful Votes: 0
  • Replies: 5
  • Views: 2,660

 

Tags: , ,

This entry was posted on Thursday, June 18th, 2009 at 5:09 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.

  • About Me

    A little something about you, the author. Nothing lengthy, just an overview.