Friday, February 24, 2012

Logging thousands of errors

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.

Where are you seeing these errors?|||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.
|||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|||

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?

|||

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

No comments:

Post a Comment