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.

 
 
« February 2025»
SunMonTueWedThuFriSat
      1
2345678
9101112131415
16171819202122
232425262728
 
Links
 
Quote
« Debating Windows vs. Linux vs. Mac is pointless: they all have their merits and flaws, and it ultimately comes to down to personal preference. »
Me