×

Q:
I have SQL 2005, 64bit version installed with SP1. I am seeing the followin
g
errors in the Windows event log:

Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.

Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.

Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.

Does anyone know what the problem is?

A:
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you’d like to know what this problem is.

Based on my experience, this issue could occur if the “Performance Logs and
Alerts” service runs as “Network Service”, which is member of “Performance
Log Users” local user group, does not have enough permission to SQL setup
folder.

SQL Setup grants read/execute permissions to “Performance Log Users” local
user group for the DLL only. “Performance Log Users” doesn’t have any
permissions for the containing folder. Granting “List folder contents”
permission to “Performance Log Users” for the containing folder (SQL Server
binn directory) may fix this problem:

D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin