SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.
While Creating BLG file for SSAS counters getting below mentioned error message:
System Log:
Event Type: Error
Event Source: SideBySide
Event Category: None
Event ID: 59
Date: 12/1/2008
Time: 1:52:35 AM
User: N/A
Computer: DBANALYSIS01
Description:
Generate Activation Context failed for d:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied.
For more information, see Help and Support Center at https://go.microsoft.com/fwlink/events.asp
Application Log:
The description for Event ID ( 6 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: OlapQueryLog
Solutoin
3 things you need to check:
First:
Check that the following accounts/groups have permissions on the <%System_Drive%>\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin directory:
CREATOR OWNER -> Special
SYSTEM -> Full control
SQLServer200xMSOLAPUser$<Machine_Name>$<Instance_Name>(<Machine_Name>\SQLServer200xMSOLAPUser$<Machine_Name>$<Instance_Name>
-> Read & Execute List folder contents Read
Administrators -> Full Control
Also check to make sure that the following accounts/groups have permissions on the msmdctr90.dll file:
System -> Full control
SQLServer200xMSOLAPUser$<Machine_Name>$<Instance_Name>(<Machine_Name>\SQLServer200xMSOLAPUser$<Machine_Name>$<Instance_Name>
-> Read & Execute Read
Administrators -> Full Control
Performance Monitor Users(<Machine_Name>\Performance Monitor Users)
-> Read & Execute Read
Performance Log Users(<Machine_Name>\Performance Log Users)
-> Read & Execute Read
Second:
Also set the logon for "Performance log and alert" service to local System account, instead of the default Local Service account,
“Run->Services.msc->Look for Performance Log and change its Logon Account”
Third:
Run LODCTR and pass msmdctr.ini as the input parameter. The msmdctr.ini file by default is located in <%SystemDrive%>:\Program files\Microsoft SQL Server\MSSQL.x\OLAP\bin.
The syntax would be
lodctr msmdctr.ini.
If that fails, take a look at https://support.microsoft.com/kb/188769
Comments
- Anonymous
December 11, 2008
Configuring Datapump in IIS 7 SSAS (64 Bit) and Oracle Client Issues Issue while Saving BLG File related