Event ID 1023 Perflib MSSQLServerOLAPService

You may find that granting permissions to the Network Service as described in http://support.microsoft.com/?kbid=912399 doesn’t work for you.
What resolved the issue for me, was granting the permissions mentioned in the link to the account used by the SQL Server Agent service. The SQL Server Agent service account was responsible for the reported errors due to service account not having access to the required Analysis Services files/folders by default.
Also, if the SQL Server Agent service account isn’t a local administrator on the server, you may find that adding the service account to the local ‘Performance Log Users’ and ‘Performance Monitor Users’ security groups usually gets around most performance counter issues without granting excessive permissions.

Leave a Reply