Solved

Event ID: 1023 Windows cannot load extensible counter DLL MSSQL$SBSMONITORING

Posted on 2009-05-13
3
4,728 Views
Last Modified: 2012-05-06
I have a SBS 2003 SP2 that is getting the below two errors in my Application log three to four times an hour.

Event Type:      Error
Event Source:      Perflib
Event Category:      None
Event ID:      1023
Date:            5/13/2009
Time:            9:58:40 AM
User:            N/A
Computer:      W2K3SVR
Description:
Windows cannot load extensible counter DLL MSSQL$SHAREPOINT, the first DWORD in data section is the Windows error code.

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

-------------
Event Type:      Error
Event Source:      Perflib
Event Category:      None
Event ID:      1023
Date:            5/13/2009
Time:            9:58:40 AM
User:            N/A
Computer:      W2K3SVR
Description:
Windows cannot load extensible counter DLL MSSQL$SBSMONITORING, the first DWORD in data section is the Windows error code.

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

I searched the knowledgebase and found references to http://support.microsoft.com/kb/912399 however, that did nothing for me.

Has anyone seen this before and if so, help...

I do not see anything in the System Log that is related.
0
Comment
Question by:steele2007
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
Did you grant the Read & Execute permission to the Network Service account on the performance counter ?
If so maybe try reinstalling the monitoring service.

Gary
0
 

Author Comment

by:steele2007
Comment Utility
I followed the directions in the microsoft article and that did not work, mainly because I did not have the files or paths referenced.  I did notice two directories in the SQL directory that reference MSSQL$SHAREPOINT and MSSQL$SBSMONITORING, so... I went in there and gave Read and Execute permissions to all the DLL files in Binn directories and the errors have stopped.

Thanks, you pointed me in the right direction.  Appreciate it.
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Glad to help!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now