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 http://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 http://support.microsoft.com/kb/188769


 


 


 


 

Comments (1)

  1. BI_Knowhow says:

    Configuring Datapump in IIS 7 SSAS (64 Bit) and Oracle Client Issues Issue while Saving BLG File related

Skip to main content