Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 912399 - Last Review: April 13, 2006 - Revision: 1.2
Event ID: 1023 occurs, and counter data is not logged when you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters
Bug #: 664323 (SQL Server 9.0)
SYMPTOMS
Consider the following scenario. On a Microsoft Windows XP-based computer, you use Performance Monitor to collect data from Microsoft SQL Server 2005 Analysis Services performance counters. You try to log the counter data by using the performance logs and alerts. When you start to collect data, you notice that the counter data is not logged, and one or more events that are similar to the following are logged in the event log:
Event Type: Error
Event Source:
Perflib
Event Category: None
Event ID: 1023
Date:
Date
Time:
Time
User: N/A
Computer:
ComputerName
Description: Windows cannot load
extensible counter DLL ServiceName, the first DWORD
in data section is the Windows error code.
and
Time represent the time that the event
occurs.
ComputerName represents the name
of the computer.
ServiceName represents the name of the corresponding service for the SQL Server performance
counters.
CAUSE
This problem occurs because the Performance Logs and Alerts service (Smlogsvc.exe) does not have sufficient permissions to access the performance counter DLL or the "bin" directory and "bin\en" directoryfor SQL Server 2005 Analysis Services.
On a Windows XP-based computer, the Performance Logs and Alerts service runs under the Network Service account. However, the Network Service account has limited permissions on the local computer. The Network Service account cannot access the performance counter DLL or the SQL Server 2005 Analysis Services "bin" directory and the "bin\en" directorywhen you collect data from SQL Server 2005 Analysis Services performance counters.
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
Note MSSQL.x represents the corresponding value for the instance ID in the system.
For more information about how to grant permissions to a specific folder in Windows XP, click the following article number to view the article in the Microsoft Knowledge Base:
308419 Â
(http://kbalertz.com/Feedback.aspx?kbNumber=308419/
)
How to set, view, change, or remove special permissions for files and folders in Windows XP
STATUS
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
MORE INFORMATION
The following lists the related performance counter DLLs for SQL Server 2005 components:
-
Data transformation pipeline performance counters
C:\Program Files\Microsoft SQL Server\90\Dts\Binn\Dtspipelineperf.dll
-
SQL Server 2005 Analysis Services performance counters
C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Bin\Msmdctr90.dll
-
Microsoft PKM Search service performance counter
C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Binn\Msfte.dll
-
SQL Server service performance counters
C:\WINDOWS\System32\Sqlctr90.dll
- SQL Server Agent service performance counters
C:\WINDOWS\System32\Sqlagentctr90.dll
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
| kbsql2005as kbexpertiseadvanced kbprb KB912399 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please