When you install Microsoft SQL Server 2012 or SQL Server 2012 Analysis Services and use the default account as a service account for these applications during the installation, the services start fine but you see several errors listed in the Event Viewer in the Application Log that are related to Error 1032. There are at least 3 events logged for Error 1032 from source ESENT with Event ID 455, 489, and 490.
Event ID 455 is logged with the following description.
sqlservr (1476) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.
Event ID 489 is logged with the following description.
sqlservr (1476) An attempt to open the file “C:\Windows\system32\LogFiles\Sum\Api.log” for read only access failed with system error 5 (0×00000005): “Access is denied. “. The open file operation will fail with error -1032 (0xfffffbf8).
Event ID 490 is logged with the following description.
sqlservr (1932) An attempt to open the file “C:\Windows\system32\LogFiles\Sum\Api.chk” for read / write access failed with system error 5 (0×00000005): “Access is denied. “. The open file operation will fail with error -1032 (0xfffffbf8).
As you can see, the system is unable to read Api.chk and Api.log files in C:\Windows\system32\LogFiles\Sum folder. According to Microsoft KB article 2811566, this is a known issue in SQL Server 2012 and Microsoft doesn’t have a solution quite yet.
As a workaround, you can manually set permissions for the service accounts that are used by SQL Server (sqlservr.exe) and SQL Server Analysis Services (msmdsrv.exe) to access the C:\Windows\System32\LogFiles\Sum folder. The sum folder is for the Software Usage Metrics (SUM) feature that uses the User Access Logging Service in Windows Server 2012.
Copyright ©2014 Zubair Alexander. All rights reserved.
Copyright ©2002-2013 Zubair Alexander. All rights reserved.
30 queries. 0.708 seconds