SQL Server Power Search - Get More Relevant Results

Event Log Error - Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui

"Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui" is an error in the System event log with Event Id: 59 and Source: SideBySide. This is accompanied by another error with same source and event id with the following text:

"Generate Activation Context failed for c:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied"




I have seen this on several servers and the solution has been the same every time.

Check which account the Performance Logs and Alerts service runs as. It is probably Network Service. This account does not have access to c:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\. To resolve it, give the local group Performance Log Users permission to List Folder Contents for that folder.

The steps are as follows:
  1. Right-click on c:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\ and select Sharing and Security...
  2. Select the Security tab
  3. Click the Locations button and select the name of the local computer
  4. Click the Advanced button then Find Now
  5. From the list double-click on the group called Performance Log Users
  6. Ensure the List Folder Contents checkbox in the Allow column is checked, and click OK

This is a common error and not always caused by the reasons described here, but when accompanied by the "Generate Activation Context..." message on a server with SQL Server installed you should definitely follow the steps I have outlined, as that is the most likely solution.

 
Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!



Do you have a question about SQL Server? Would you like to answer a question?

Go to the SQL FAQ to get started.