Backtrack:  
 
by lunarg on February 12th 2018, at 13:36

When starting up SQL Server or Analysis Services on Server 2012, you may encounter errors in the Application event log, even though SQL Server itself seems to operate normally:

ESENT error 1032
sqlservr (3472) An attempt to open the file "C:Windowssystem32LogFilesSumApi.log" for read only access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).

Cause

These errors are logged due to insufficient permissions for the service startup accounts for SQL Server and Analysis Services when the services access the following folder for logging as a part of the Software Usage Metrics feature: C:\Windows\System32\LogFiles\Sum

Resolution

To resolve the issue, give read/write permissions (full control is not necessary) to the service accounts which are running SQL Server and Analysis Services on the folder C:\Windows\System32\LogFiles\Sum.

 
 
« April 2024»
SunMonTueWedThuFriSat
 123456
78910111213
14151617181920
21222324252627
282930    
 
Links
 
Quote
« Have you tried turning it off and on again? »
The IT Crowd