SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.

  • Article

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