Solved

Hundreds of Perflib Event ID 1023 "Windows cannot load extensible counter DLL MSSQL$SHAREPOINT",

Posted on 2011-02-24
5
175 Views
Last Modified: 2014-11-26
During an EE search through knowledge base I found a solution writting by EE Genius, tbsgadi, who suggested to grant the Read & Execute permission to the Network Service account on the performance counter.

I was wondering how to do this?

Thanking you in advance
0
Comment
Question by:micror
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 10

Expert Comment

by:APNFSSC
ID: 34976031
0
 
LVL 1

Author Comment

by:micror
ID: 35102202
Many thanks for taknig the time to reply to my question. I greatly appreciate it.
The specific events are related to MSSQL$SHAREPOINT and MSSQL$SBSMONITORING.
I noted the dependancies wiithin the Services console and applied the appropriate rights, however, it prevented the services from restarting.
0
 
LVL 10

Accepted Solution

by:
APNFSSC earned 500 total points
ID: 35102276
on the link above it describes those two as being fixed by:

- Counter: MSSQL$SHAREPOINT and MSSQL$SBSMONITORING - Inspired by PaulD's solution and a newsgroup post, I did a search in "program files" for sqlctr80.dll. I found two copies, one for each MSSQL instance listed above, in the following locations:
C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING\Binn
C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Binn

For each file, I modified the Properties, selected the Security tab and added "Everyone" with "Read & Execute" rights. My application event log stopped recording these events immediately.



0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
can ping yahoo.com but can't browse to via IE 5 78
DNS and A Record questions... 2 113
ISP Redundancy using IP SLA Monitor 2 53
eigrp routing loop 5 79
Preface There are many applications where some computing systems need have their system clocks running synchronized within a small margin and eventually need to be in sync with the global time. There are different solutions for this, i.e. the W3…
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

696 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