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.

 
 
« March 2021»
SunMonTueWedThuFriSat
 123456
78910111213
14151617181920
21222324252627
28293031   
 
Links
 
Quote
« I needed a password with eight characters so I picked Snow White and the Seven Dwarves. »