Problem

"Generate Activation Context failed for C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL."

and

"Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied."

Solution

To resolve this issue you have to give the "Performance Log Users" List Folder Contents permissions, which is on the Security tab of both of the following folder locations:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin

...

This happens because the account under which runs the Performance Logs and Alerts service (NT Authority\NetworkService) doesn?t have access to these folders.