Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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
Article ID: 912399 - View products that this article applies to.
Bug #: 664323 (SQL Server 9.0)
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:
Note Date 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.
Event Type: Error
Event Source: Perflib
Event Category: None
Event ID: 1023
Description: Windows cannot load extensible counter DLL ServiceName, the first DWORD in data section is the Windows error code.
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.
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.dllAdditionally, 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:
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:
(http://support.microsoft.com/kb/308419/ )How to set, view, change, or remove special permissions for files and folders in Windows XP
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The following lists the related performance counter DLLs for SQL Server 2005 components: